How to answer the question how many fakt table in your
datawarehouse and what size it have?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rose
Check this you have detail explanation
http://www.1keydata.com/datawarehousing/fact-table-types.html
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gopal
There are 3 fact tables
Cumulative
Snapshot
Fact less fact table
Is This Answer Correct ? | 3 Yes | 6 No |
What is a full backup?
What is the function of etl when used in data warehousing?
how to calculate sum(sal) with out using aggregator satge
3.What is fact less fact ?
9 Answers Accenture, HCL, TCS,
What is the difference between Datawarehouse and OLAP?
What is aggregate fact table?
How can we do data cleaning?
How do you define data block size?
What is a star schema? Why does one design this way?
Explain the data type of the surrogate key?
Difference between cold fusion mx 6 and cold fusion mx 7?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?