How to answer the question how many fakt table in your datawarehouse and what

How to answer the question how many fakt table in your
datawarehouse and what size it have?

Question Posted / nit

3 Answers
7349 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to answer the question how many fakt table in your datawarehouse and what size it have?..

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

How to answer the question how many fakt table in your datawarehouse and what size it have?..

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

How to answer the question how many fakt table in your datawarehouse and what size it have?..

Answer / gopal

There are 3 fact tables

Cumulative
Snapshot
Fact less fact table