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
- 9460 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 can report net connect multiple datasource at a time in report creation time?
What are the possible data marts in retail sales?
What is data analysis? Where it will be used?
What is recovering sessions?
Explain what are the different methods of loading dimension tables?
What are the differences between star and snowflake schema?
Explain the definition of normalized and denormalized view?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Code the tables statement for a single-level (most common) frequency?
What are the advantages and disadvantages of reporting directly against the database?
Explain degenerate dimension table?
What is an er diagram?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
Explain what is the metadata extension?
