Interested to Buy Any Domain ? << Click Here >> for more details...
which table we load first in DW. dimension or fact? why?
- 4 Answers
- 7850 Views
- IBM, JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
what is the main advantage of impromptu over cognos reportnet?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate What is difference between informatica power mart and power center? What is called a slice? Can you define metrics designer? hi all i am searching for cognos jobs pls inform about the
jobs to:santosh.koora@gmail.com How to test a cube? What is the function of cognos dispatcher? Can the expiration parameter of 365 in the cognos 8
configuration
how to increase common symmetric key lifetime in days Define the cognos reporting tool? -------------What is Coditional Prompting? Can you define framework manager? how to test reports in cognos? What is the difference b/w macros and prompt?
