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
- 7991 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
Explain why denormalization is promoted in universe designing?
What is load manager?
Explain what are the modules in power mart?
Explain what are the advantages data mining over traditional approaches?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
What are data modeling and data mining?
What is operational data store (ods)?
What is cost benefit analysis (cba)?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
what are the different views that are considered when building an object-oriented software system?
What is meant by metadata in context of a data warehouse?
Is there any difference in testing database and data ware housing?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What are the tools available for etl?
Explain what are the different methods of loading dimension tables?
