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

Answer Posted / rose

Check this you have detail explanation

http://www.1keydata.com/datawarehousing/fact-table-types.html

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is incremintal loading?

754


What are the types of dimensional modeling?

818


Explain the differences between normalizer and normalizer transformation?

710


Can any one explain about core dimension, balanced dimension, and dirty dimension?

833


What is a core dimension?

813


What is type 2 version dimension?

757


Explain what is the difference between powerplay transformer and power play reports?

829


Explain which columns go to the fact table and which columns go the dimension table?

698


Explain what is partitioning? What are the types of partitioning?

724


What is critical column?

872


What is a hash cluster?

738


What are partition points?

745


What is a relationship?

743


Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

750


Explain what is the metadata extension?

782