Interested to Buy Any Domain ? << Click Here >> for more details...
How to answer the question how many fakt table in your
datawarehouse and what size it have?
- 3 Answers
- 8463 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 what is the difference between power center & power mart?
what is indexing ? what are different types of indexes supported by oracle ?
What are the advantages of query studio compared to report studio?
Explain er diagram?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What are the different types of data warehouses?
Explain why should you put your data warehouse on a different system than your oltp system?
What is a star schema? Why does one design this way?
What is the main difference between schema in rdbms and schemas in datawarehouse?
how can one connect two fact tables ? is it possible ? how?
What is the difference between filter and lookup transformation?
capital of tamilnadu
Teradata 
