Interested to Buy Any Domain ? << Click Here >> for more details...
which table we load first in DW. dimension or fact? why?
- 4 Answers
- 8101 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 |
Is it possible to join multiple Databases in a Catalog?
What are all types of Batches?
How do you call a store procedure within a transformation?
What is difference between page break and section report?
What are the differences between Cognos 8 and Cognos 7.x version?
What is Report item
what is prompt types of prompt example briefly each types of product (eg:values, date,search,prompt etc.)
What are all the types of gateway used in Cognos?
what is the difference between filter and condition?
How do we create Links & Segments in Cognos Framework Manager?
what are typees of dimensions
Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and it's having 2 columns which are having long text as a value (BLOB data type). Report is displaying entire text items in HTML format, but when I'm exporting it into EXCEL it's give me ##########. How to correct (wrap) it in Excel? so when end users they are directly running that report in Excel so instead of seeing ######### for long text items they should see the entire text items in those columns. Please advice!
Teradata 
