Interested to Buy Any Domain ? << Click Here >> for more details...
if we increase the number of dimensions will the rows in
fact table increase or decrease??
- 3 Answers
- 9392 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / asha
Number of rows wouldn't increase. Number of cloumns will
increase in fact table as we will have to store the keys of
those dimensions.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain what is fact less fact table? Where you have used it in your project?
What is the use of dimensional modeling in data warehousing?
I have two universes created by two difference database can we join them in designer & report level? How
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
What is edw?
I need a good brd and uc template?
What is pre-emptive and non-pre-emptive?
Explain dimension table ?
What is degenerate dimension table?
Fact table is in normalized or de-normalized form?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
How to improve session performance in aggregator transformation?
What are steps we have to follow in designing the userfriendly universe?
What is the difference between olap and datawarehosue?
