which table we load first in DW. dimension or fact? why?
- 4 Answers
- 8199 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 |
What is the use of report studio?
3. What was the size of your cube?
What DB View and Bus View?
How to test a cube?
How will u execute a stored procedute from a reportstudio
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
What is content store?
write a query to display the third record from the employee table?
What are the types of studio?
How can I disable the drill-down for the last level of my dimensional hierarchy ????
In a Single page we are having 3 list. While running each has to populated in separate page?
What is Normalization?
Teradata 
