which table we load first in DW. dimension or fact? why?
- 4 Answers
- 6427 Views
- IBM, JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / asish mohapatra
We should first load dimension table then the fact table .
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Why cognos decision stream is used?
What is difference between primary key and unique key constraints?
What junk dimension contains?
Can you define a catalog and types of catalogs in cognos?
write a query to display the departments with no employee?
What is the difference between Open Connection command ang Open Session Command?
what are the errors faced while bursting the reports and how to solve those errors?
what are slowly changing dimensions? Why we are used scd?
Can you define fan trap?
What are the components used in web tier?
Can you define drill down and drill up?
Define the slice and dice?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
What is the function of cognos dispatcher?
