Interested to Buy Any Domain ? << Click Here >> for more details...
which table we load first in DW. dimension or fact? why?
- 4 Answers
- 8095 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 |
how you provide security to reports? How you provide security to packages ?
How to perform single signon in Cognos by using URL?
Hi..I have COG-112(Report Author),COG-122(Admin),COG-132(Meta data modelling). I took test end of Sep '09.I got 100% wcore with these dumps. If any body need then mail me on kris.bi121@gmail.com
what are typees of dimensions
Which service handles requests for cognos connection,query studio and event studio.
what is the difference between cascading prompt and drill-thru
Explain what is the difference between native sql and cognos sql?
How many number of cubes can we create on a single model? How can we navigate between those cubes?
How is possible this scenario using in type-in prompt.?
What are the different ways of adding data in Transformer?
How can you link a query to a data container manually in Report Studio?
set scope level in transformer
Teradata 
