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

Answer Posted / gopal

There are 3 fact tables

Cumulative
Snapshot
Fact less fact table

Is This Answer Correct ?    3 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to generate the cubes in framework manager?

548


Explain what are the possible data marts in retail sales?

499


What is the difference between Datawarehouse and OLAP?

528


What is the difference between data warehouse and operational systems?

592


Explain swot analysis?

623






Explain what is the data type of the surrogate key?

573


What are the mapping paramaters and maping variables?

563


How to allow a dynamic selection of a column for a measure in a chart,without using variable?

506


How are the dimension tables designed?

559


Explain the hierarchies level data warehousing.

504


Can you state some of the innovations throughout history?

542


Explain me what are conformed dimensions?

537


In document how to create metrics?

551


Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

1884


What is data analysis? Where it will be used?

553