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
- 8601 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 the definition of cube in datawarehousing?
How much data hold in one universe.
Explain how to get the first 100 rows from the flat file into the target?
What are Data Marts?
What are steps we have to follow in designing the userfriendly universe?
what are the major three types of modeling used?
0 Answers InfoAxon Technologies,
I have two universes created by two difference database can we join them in designer & report level? How
Store (and count) non-fact records?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
What is a fact table?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain what are components of report studio?
Teradata 
