Data Warehousing Question:
How Many different schemas or DW Models can be used in Siebel Analytics. I know Only STAR and SNOW FLAKE and any other model that can be used?
Answer:
Integrated schema design is also used to define an integrated schema design we have to define the following concepts
► Fact constellation
► Act less fact table
► Onformed dimension
A: Â A fact constellation is the process of joining two or more fact tables
B: A fact table with out any facts is known as fact less fact table
C:A dimension which is re useful and fixed is known as conformed dimensionA dimension, which is, shared with multiple fact tables known as conformed dimension
► Fact constellation
► Act less fact table
► Onformed dimension
A: Â A fact constellation is the process of joining two or more fact tables
B: A fact table with out any facts is known as fact less fact table
C:A dimension which is re useful and fixed is known as conformed dimensionA dimension, which is, shared with multiple fact tables known as conformed dimension
Previous Question | Next Question |
What is drilling across? | What is an error log table in Informatica occurs and how to maintain it in mapping? |