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
- 9094 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 defined as partial backup?
What is meant by metadata in context of a data warehouse?
Explain what are the advantages of query studio compared to report studio?
Explain grouped cross tab?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
What is the difference between filter and lookup transformation?
What are the main steps to build the data warehouse?
What are the steps of implementing data warehousing?
How to define a cube??
What is called dimensional modelling?
What is vldb(very large databases)?
what is an use case?
Explain in detail abt measure objects? And what is the use of it? How to create it?
Explain the main difference between inmon and kimball philosophies of data warehousing?
How much data hold in one universe.
