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
- 8482 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 |
What is data cleaning? How can we do that?
What is the difference between a primary and secondary actor in use case modeling?
Explain why denormalization is promoted in universe designing?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
Suggest a good author for hyperion in data warehousing?
Define data warehouse?
What is real-time datawarehousing?
Difference between cold fusion mx 6 and cold fusion mx 7?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
What are the advantages of raid 1, 1/0, and
What is a data warehousing?
Why facts table is useful in representing the data?
Teradata 
