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 are the different types of join operations?
Explain can a dimension table contains numeric values?
Explain piconet?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
What are the tools available for etl?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
What are the other names given to data warehousing?
Compare ?Data mining? and ?Data Warehousing??
what is query optimizer? what are different types of optimizer s supported by oracle ?
How many repositories can we create in Informatica?
Compare aggregates and data marts
What is difference between Business Objects and Hyperion Essbase? Please help me