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
- 8028 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 factless fact tables?
Explain what are the various transformation available?
What are fact, dimension, and measure?
What is bi?
Start a batches with in a batch?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What is meant by metadata in context of a data warehouse and how it is important?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
How to test report in reportnet?
Explain bus schema?
Is union transormation is active transformation?
Explain the differences between normalizer and normalizer transformation?
What is dimensional modelling?
Can decision tree be implemented using SQL?
What is a Decision Tree Algorithm?
