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 |
What is the difference between aggregate table and materialized view?
What is vdl (view definition language) explain?
What is cost benefit analysis (cba)?
What is a staging area? Do we need it? What is the purpose of a staging area?
How to test report in reportnet?
what is data validation strategies for data mart validation after loading process
What is a relationship?
What is Operational Data Store?
What is metadata in context of a datawarehouse and how it is important?
What are loops in Datawarehousing?
What are the methodologies of data warehousing?
What is the difference between Datawarehouse and OLAP?