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
- 9101 Views
- Extech, Principal Finance, I also Faced
- E-Mail Answers
Answer Posted / henry
Dimensions are wide - facts are deep.
T1 will be dimension table (example "customer" with all the
related attributes like address, tel etc)
T2 will be your fact table (example "orders") which uses
one column as surrogate key to link to T1 ("customers" in
this case)
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Explain is olap databases are called decision support system true/false?
What are situations where snowflake schema is better than star schema when the opposite is true?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Can we take backup when the database is opened?
Where the cache files stored?
what are the others of "bad files" and "discard files" when using sql*loader?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
Explain Association algorithm in Data mining?
Can you state some of the innovations throughout history?
What is data analysis?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is the difference between olap and oltp?
What are data modeling and data mining?
Explain what are conformed dimensions?
What is perform recovery?
