Answer Posted / 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 |
Post New Answer View All Answers
What is the main difference between schema in rdbms and schemas in datawarehouse?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is the difference between olap and datawarehosue?
Explain what are slowly changing dimensions?
What is latest version of power center / power mart?
Explain about core dimension, balanced dimension, and dirty dimension?
How do you create surrogate key using ab initio?
ware house management system is used?
What is the use of dimensional modeling in data warehousing?
What is the difference between power center and power mart?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
What is perform recovery?
What are the different types of join operations?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?