Data Warehousing Question: Download Questions PDF
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
Download Data Warehousing Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is drilling across? | What is an error log table in Informatica occurs and how to maintain it in mapping? |