Explain What type of Indexing mechanism do we need to use for a typical datawarehouse?
Submitted by: AdministratorOn 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.
Submitted by: Administrator
To my knowledge, SQLServer does not support bitmap indexes. Only Oracle supports bitmaps.
Submitted by: Administrator
Read Online General Datawarehousing Job Interview Questions And Answers
Top General Datawarehousing Questions
| ☺ | What is SCD1 , SCD2 , SCD3? |
| ☺ | What is ODS? |
| ☺ | Explain piconet? |
| ☺ | Explain the Difference between OLTP and OLAP? |
| ☺ | Explain What are the Different methods of loading Dimension tables? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
