How to answer the question how many fakt table in your
datawarehouse and what size it have?
- 3 Answers
- 8795 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
Explain reference cursor?
How many ways we test the universe & Report?
What are the design methods of data warehousing?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
How to stop a batch?
What is a cube in data warehousing concept?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
2.What is staging area ?
4 Answers HCL, IBM, iFlex, TCS,
how to calculate sum(sal) with out using aggregator satge
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
What is data warehosuing hierarchy?
How to generate iqd file from framework manager?
Teradata 
