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
- 8705 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 |
4.Explain Snowflkeschema ?
6 Answers EDS, HCL, IBM, iFlex, TCS,
I need to set predefined condition. How I do this?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
Code the tables statement to produce a multi-level frequency?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
What is analytical or analytic mean?
in general which algorithms for used?
What is surrogate key? Where we use it?
Explain what is ods (operation data source)?
What is the difference between Oracle Express and Oracle Discoverer?
What is bi?
wat is code review and wat actually srs or how can we create HLD,LLD.PLS,GIVE ME ANSWER AS EARLY AS FAST.
Teradata 
