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
Define data warehouse?
Explain datawarehousing?
what is difference between drill & scope of analysis?
Explain bus schema?
Explain some of modeling tools available in the market?
Explain what is fact less fact table? Where you have used it in your project?
What are the other names given to data warehousing?
What is crass reference table?
Database in use is oracle?
Explain what is the extension of file to save template?
Explain how to export mappings to the production environment?
Can we take backup when the database is opened?
Which component has onread method and what it is used for?
Code the tables statement for a single-level (most common) frequency?
Explain what is real time data-warehousing?