Explain is fact table?



Explain is fact table?..

Answer / Ravi Kumar Shukla

In data warehousing, a Fact Table stores measures or facts about the business entities. Each row in a fact table represents an event and contains foreign keys that link to corresponding dimensions (descriptive attributes) in dimension tables. Fact tables usually have a primary key composed of multiple columns.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

What are components of reportnet?

1 Answers  


Explain some of modeling tools available in the market?

1 Answers  


What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

1 Answers  


What is informatica architecture?

1 Answers  


what is the difference between etl tool and olap tools

3 Answers  


How does data mining and data warehousing work together?

2 Answers  


What is the difference between view filter and report filter?

1 Answers  


What is called dimensional modelling?

1 Answers  


How much data hold in one universe.

1 Answers  


Explain what is the limit to the number of sources and targets you can have in a mapping?

1 Answers  


Explain the definition of normalized and denormalized view and what are the differences between them?

1 Answers  


Is there any default username & pwd for bo designer & supervisor?

1 Answers  


Categories