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

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

Is This Answer Correct ?    3 Yes 6 No

Post New Answer

More Data Warehouse General Interview Questions

What is a full backup?

0 Answers  


What is the function of etl when used in data warehousing?

0 Answers  


how to calculate sum(sal) with out using aggregator satge

3 Answers   HSBC,


3.What is fact less fact ?

9 Answers   Accenture, HCL, TCS,


What is the difference between Datawarehouse and OLAP?

0 Answers  






What is aggregate fact table?

0 Answers  


How can we do data cleaning?

0 Answers  


How do you define data block size?

0 Answers  


What is a star schema? Why does one design this way?

3 Answers  


Explain the data type of the surrogate key?

0 Answers  


Difference between cold fusion mx 6 and cold fusion mx 7?

0 Answers  


Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

0 Answers  


Categories