which table we load first in DW. dimension or fact? why?
- 4 Answers
- 6423 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 the function of cognos dispatcher?
How to create a cube in Transformer? What is the process? Please mention process thank u
Define report item?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
What is a Datastore in Cognos?
how to create cubes in transformer ?
hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com
Can you explain a cognos controller?
What is the use of Cognos scenario?
What is the importance of having monitor service in cognos?
What are the themes in a data warehouse?
Name the types of report?
What is metric store database?
explain how to create powerplay reports?
What are all the advantages of Cognos?
