What are the different types of Fatcs?
Explain with example only
Answer Posted / nasa
Facts are 3
-Additive
-Semi Additive
-Non Additive
Additive:: A value which can sumd up at any dimension
Semi Additive:: A value which can sumd up at only some dimensions
Non Additive:: A value which can't sumd up at any dimension
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are vaious etl tools in the market?
What is the difference between filter and lookup transformation?
What are the key columns in Fact and dimension tables?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
How to provide security in frame work manager for a query subject?
Explain what is the difference between power center & power mart?
What is the difference between er modeling and dimensional modeling?
What are parallel querys and query hints?
How to load the time dimension?
Explain differences between star and snowflake schemas?
What is aggregate fact table?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What is the difference between mapping parameter & mapping variable in data warehousing?
What is normalization, first normal form, second normal form, third normal form?
What is perform recovery?