Which kind of index is preferred in DWH?

Question Posted / guest

Which kind of index is preferred in DWH?..

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

More Data Warehouse General Interview Questions

What is surrogate key? Where we use it?

What are the different ways to represent the loading of dimension tables?

Explain the structure of cold fusion?

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?

What are templates in which way it is help full?

How to add a number to a macro variable?

what is the difference between etl tool and olap tools

Explain why dimenstion tables are denormalized in nature?

What are the vaious etl tools in the market?

State any 5 of Cods guidelines of an OLAP system, brief description each?

Explain is fact table?

What is difference between e-r modeling and dimensional modeling?

For more Data Warehouse General Interview Questions Click Here