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 what are the different types of data warehousing?
Can decision tree be implemented using SQL?
How are the dimension tables designed?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
What is aggregate fact table?
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 application.cfm?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Code the tables statement for a single-level (most common) frequency?
Explain vldb?
Explain dimensional modelling?
Why facts table is useful in representing the data?
What are the reasons to use a chameleon method in data warehousing?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?