Interested to Buy Any Domain ? << Click Here >> for more details...
which table we load first in DW. dimension or fact? why?
- 4 Answers
- 8088 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 |
hai dis Ashok Sahu I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.
How can I disable the drill-down for the last level of my dimensional hierarchy ????
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
What is Metrics designer?
------------------What is Inline Query?
what is the difference between rollup aggregation and aggregation ?
What are all the advantages of Cognos?
suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?
If anybody need certification dumps like COG-112 COG-122 COG-132 THEN MAIL ME ON kris.bi121@gmail.com.all are latest dumps test taken on july-09
Which studio is used to create reports?
How to crate cubes in transformer ?
what is the difference between native sql and cognos sql?
Teradata 
