Interested to Buy Any Domain ? << Click Here >> for more details...
If I have table T1 and table T2
T1 has 250 cols and 10,000 rows
T2 has 2 billion rows and 10 cols
Which one would be Fact table and which one would be
Dimension table and why ?
- 3 Answers
- 9447 Views
- Extech, Principal Finance, I also Faced
- E-Mail Answers
Answer Posted / nithin
A table being set as a Fact or Dimension depends on the
kind of data it stores.Measures and keys are stored in
Facts and Dimension stores a primary key and other
information depending up on the dimension.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is an er diagram?
What is a real-time data warehouse?
Explain the data type of the surrogate key?
What are the steps to build the datawarehouse?
What is the main difference between inmon and kimball philosophies of data warehousing?
What are the different types of datawarehosuing?
Explain what is the limit to the number of sources and targets you can have in a mapping?
What is Analysis Services?
What is meta data and system catalog?
What is mean by aggregate aware?
What are the steps involved in designing a fact table?
What is data analytics in simple terms?
What is a core dimension?
What are the different types of data warehousing?
What are the different types of join operations?
