How to answer the question how many fakt table in your
datawarehouse and what size it have?
Answer Posted / yaseen mohammad
There are three types of facts
1) Additive fact-----------which adds all dimensions for getting meaning full sentence Ex: sales_amount which adds dimensions like product,store,time
2) semi additive fact-------which adds some dimensions for getting meaning full sentence
3) Non additive fact------which does not get meaning full sentence by adding dimensions
Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Explain how many ways you create ports?
What is data stream and data adaopter?
What are fundamental stages of data warehousing?
Explain the hierarchies level data warehousing.
Explain differences between star and snowflake schemas?
What are the types of partitioning?
What are the possible data marts in retail sales?
What is meta data and system catalog?
Explain clustering algorithm?
What are different deliverables according to phases?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Explain how are the dimension tables designed?
Explain degenerate dimension table?
In microstrategy, how can we direct the sql generated to use a specifc table?
What are the types of dimensional modeling?