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 difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What are the steps involved in designing a fact table?
What is the difference between drill through and masterdetail reports?
What is called dimensional modelling?
Explain what is the difference between powerplay transformer and power play reports?
What are target types on the server?
Explain the main difference between inmon and kimball philosophies of data warehousing?
How can we run the graph? What is the procedure for that?
What is the difference between snowflake and star schema?
Explain er diagram?
How to create context?
What are the various methods of getting incremental records or delta records from the source systems?
Explain what is fact less fact table? Where you have used it in your project?
What are vaious etl tools in the market?
What are the methodologies of data warehousing?
