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 is surrogate key? Explain with examples.
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 are the types of dimensional modeling?
What are Aggregate tables?
How we are using this function?
Explain the hierarchies level data warehousing.
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
For faster process, what we will do with the universe?
What is Discover and Execute in XMLA?
Compare and contrast aggregates & indexes
what are relationships?
Code the tables statement to produce a multi-level frequency?
How to export mappings to the production environment?
Explain the data type of the surrogate key?
What is operational data store (ods)?