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
- 8257 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 the difference between oltp and olap?
What are the mapping paramaters and maping variables?
How to handle multi value dimensions?
How we are using this function?
What is the difference between snowflake and star schema?
How do you define data block size?
Explain the hierarchies level data warehousing.
What are the data marts?
what is user variable in affinium campaign? and some real time examples.
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain what is data validation strategies for data mart validation after loading process?
What are the different types of scd's used in data warehousing?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
