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
- 8430 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 how many ways you create ports?
How to get the first 100 rows from the flat file into the target?
What is the differences between star and snowflake schemas?
if source contain 10records how you identify header and footer
what are different storage options supported by oracle ?
Difference between PowerPlay transformer and power play reports?
What are Aggregate tables?
How can you clear the cache?
Suggest a good author for hyperion in data warehousing?
What is a Decision Tree Algorithm?
Explain in simple terms, the concept of Data Mining.
Explain what are the various file formats involved in reportnet?
Teradata 
