Which kind of index is preferred in DWH?
- 1 Answers
- 8786 Views
- I also Faced
- E-Mail Answers
Answer / warrenrame
Bitmap index is the best one. why because B-tree is suited
for unique values(eg: empid) and Bitmap is best for repeated
values(eg: gender m/f)
| Is This Answer Correct ? | 6 Yes | 1 No |
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
Explain what are fact, dimension, and measure?
5.Explain ODS ?
What is the difference between static cache and dynamic cache?
Explain the different types of data warehousing?
Explain the difference between filter and conditin?
What are vaious etl tools in the market?
What is core dimension?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
what are different storage options supported by oracle ?
How to generate iqd file from framework manager?
Teradata 
