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 batch processing?
Whether dimension table can have numeric value?
What is the differences between star and snowflake schemas?
What is metadata in context of a datawarehouse?
Explain me what are data marts?
What are Aggregate tables?
Difference between cold fusion 5 and cold fusion mx 6?
Explain what are the advantages of query studio compared to report studio?
What does level of granularity of a fact table signify?
Explain the hierarchies level data warehousing.
I have two universes created by two difference database can we join them in designer & report level? How
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is VLDB?
What is factless fact tables?
Explain datawarehousing?