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 advantages data mining over traditional approaches?
What is the difference between snowflake and star schema?
What is data warehosuing hierarchy?
Explain the definition of normalized and denormalized view and what are the differences between them?
What is the data type of the surrogate key?
What is the difference between metadata and data dictionary?
Explain what are the various file formats involved in reportnet?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Tell me what is full load & incremental or refresh load?
What is the difference between view filter and report filter?
Where do we use semi and non additive facts?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
What is a core dimension?
What are the various file formats involved in reportnet?
What is edw?