which table we load first in DW. dimension or fact? why?
- 4 Answers
- 6396 Views
- IBM, JPMorgan Chase, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / asish mohapatra
We should first load dimension table then the fact table .
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / krishna
First we load dimension and next fact. Without dimension table there is no meaning for fact table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
how u will determine the performence tune will occur either in report or system
Define the slice and dice?
how will optimiz the performance of sql in FM ?
How you drill from powerPLay to Impromptu?Explain all Steps?
what is the security module used in cognos?
How you create IQD In ReportNet FrameWork?
i thought to keep fake experience..as a fresher i can't enter..bcos there is a large gap after my graduation..4 years..any person who enter with fake exp describe how to attend the interview process..
Is it possible to apply access manager user rights in impromptu?
What are all the advantages of Cognos?
What are the Ways to Import Data into Catalong?
i was asked what are the caluclations done by you in your report? plz give reply
How to deploy from one server to another server?
Teradata 
