Interested to Buy Any Domain ? << Click Here >> for more details...
which table we load first in DW. dimension or fact? why?
- 4 Answers
- 7690 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
Can you define pivot?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
What is a Datastore in Cognos?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
What is metric store database?
What is difference between informatica power mart and power center?
What are all the different types of prompt in cognos?
Is it possible to join multiple Databases in a Catalog?
How do we convert from Numeric to be Words?
What are the types of studio present in Cognos?
What you mean by drill across?
What do you mean by drill through report?
What do you understand by the term 'dynamic cube'?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
difference between impromptu and cognos8
