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 |
Explain what is the difference between powerplay transformer and power play reports?
Explain difference between view and materialized view?
How to load the time dimension?
What are the difference between snow flake and star schema?
Explain what is a view as it relates to system modeling?
What are the steps involved in designing a fact table?
What is the difference between er modeling and dimensional modeling?
What is data mart in data warehouse?
What are steps we have to follow in designing the userfriendly universe?
Explain some of modeling tools available in the market?
Why we use repository connectivity?
What do you mean by static and local variable?