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
How can you import tables from a database?
Explain the difference between data ware house & data mart?
Explain how to export mappings to the production environment?
What are the types of SCD?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
What are fundamental stages of data warehousing?
Explain me what are conformed dimensions?
Explain what is the difference between datawarehouse and bi?
What are loops in Datawarehousing?
Why should we use data ware housing and how can you extract data for analysis with example?
What is the purpose of Dataware Control?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What are the different types of scd's used in data warehousing?
Explain differences between star and snowflake schemas?
What are necessary tasks to install reportnet software?