which table we load first in DW. dimension or fact? why?

Question Posted / imran

4 Answers
7916 Views
IBM, JPMorgan Chase, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

which table we load first in DW. dimension or fact? why?..

Answer / asish mohapatra

We should first load dimension table then the fact table .

Is This Answer Correct ?

8 Yes

0 No

which table we load first in DW. dimension or fact? why?..

Answer / mahesh225

Dimension tables will be loaded first.

www.futuresoftworld.com
www.futureitem.com

Is This Answer Correct ?

5 Yes

0 No

which table we load first in DW. dimension or fact? why?..

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

which table we load first in DW. dimension or fact? why?..

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

Post New Answer

More Cognos Interview Questions

what is bobble chart?

1 Answers Syntel,

If there are two values at value prompt level and when selecting first value it have to go to date prompt and when selecting second value we have to get output without any prompting. How to solve this issue. if any plz mail me on this vasuattada@yahoo.co.in

2 Answers HCL,

write a query to display to 10 max record from the employee table?

8 Answers HCL,

what are the tabs in cognos ?

2 Answers

what is the difference between cascading prompt and drill-thru

4 Answers

My report output is showing data as 1 11 111 2 22 222 3 33 333 How can I sort this to 1 2 3 11 22 33 111 222 333

1 Answers

When we save a report in report studio with what extn it save?

0 Answers

how can i provide security to my reports in report studio?

3 Answers TCS,

Hi Techies..., can any one please answer me what is called unit testing ? how to do it and what are the steps involves in it? thanks for your answer......

1 Answers

what is the difference between count and running-count functions?

1 Answers

how will optimiz the performance of sql in FM ?

2 Answers Infosys,

I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

0 Answers Infosys,

For more Cognos Interview Questions Click Here