which table we load first in DW. dimension or fact? why?
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 |
architecture of cognos8
can any body explain clearly how to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible.
What's the differance between each studio in cognos 8?
How to move reports one server to another server?
Is it possible to create drill through access to other report from PDF report?
What is content store?
How we check the errors before running the report?
I want to run one page with filter and another page without filter, what is process?
write a query to display to 10 max record from the employee table?
3. Differences between Cognos Sql & Native Sql? What are their Advantages and Disadvantages?
How to pass multiple values from picklist prompt to sub report filter?
how you provide security to reports? How you provide security to packages ?