Interested to Buy Any Domain ? << Click Here >> for more details...
which table we load first in DW. dimension or fact? why?
- 4 Answers
- 7907 Views
- IBM, JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / adnan
Fact table has foreign keys referencing the primary key of dimension.
Logically Foreign key is a subset of primary or unique key. That's why , we
need to load dimension tables first and then to load fact tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is zero-foot print?
Can you define metrics designer?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
What do you understand by the term 'model durability'?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
Can you define a catalog and types of catalogs in cognos?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
What is a Transformer?
What actually a project contains?
What are the different types of reports present in cognos?
What do you mean by drill across?
how to perform single sign in cognos by using url?
What is the metric store database?
7. What is performance tuning?
