General Datawarehousing Question: Download Questions PDF
Explain What type of Indexing mechanism do we need to use for a typical datawarehouse?
Answer:
On the fact table it is best to use bitmap indexes. Dimension tables can use bitmap and/or the other types of clustered/non-clustered, unique/non-unique indexes.
To my knowledge, SQLServer does not support bitmap indexes. Only Oracle supports bitmaps.
To my knowledge, SQLServer does not support bitmap indexes. Only Oracle supports bitmaps.
Download General Datawarehousing Interview Questions And Answers
PDF
Previous Question | Next Question |
What is pre-emptive and non-pre-emptive? | What are the advantages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs? |