Interested to Buy Any Domain ? << Click Here >> for more details...
Which kind of index is preferred in DWH?
- 1 Answers
- 8663 Views
- I also Faced
- E-Mail Answers
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 Oracle features can be used to optimize my Warehouse system?
Explain functional dependency?
What is the difference between an ODS and a W/H?
What is a fact, dimension, measure?
What is the very basic difference between data warehouse and operational databases?
Difference between ODS and Staging
Explain meta data?
What is the differences between star and snowflake schemas?
What is a functional dependency f said to be minimal?
What is a real-time data warehouse?
What is a staging area? Do we need it? What is the purpose of a staging area?
Explain why denormalization is promoted in universe designing?
Teradata 
