- Why bitmap index in DWH
- Any general guidelines to allocate table space quota to different layers in ETL?
- Do Data Warehouse standards allow foreign key constraints at a dimensional model?
- How indexing works in DB for given example?
- Gather Stats Strategies for Data warehouse environment
- what will be benefit of surrogate key in data warehouse layer?
- what is recommended indexing rules for ETL in general?
- What are the Benefits of having separate layer/a dedicated schema for each layer in ETL (extract , transform and load) ?
- Invoking an select script through ODI -Cons and error logging