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
- 9314 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 what is ods (operation data source)?
What is surrogate key? Explain with examples.
Explain what are the different types of join operations?
Why facts table is useful in representing the data?
Explain the difference between dw and bi?
Explain what are the steps to build the data warehouse?
What is mean by aggregate aware?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
what is user variable in affinium campaign? and some real time examples.
What are the different ways to represent the loading of dimension tables?
Define Data Warehousing?
Explain what are the vaious etl tools in the market?
what are the major three types of modeling used?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What are the stages that are required in data warehousing?
