Problem
1 Why are the operational system keys not recommended for forming data warehouse primary keys? Give any two examples
2 Explain the following performance tuning techniques
- Data Partition
- Parallelism
3 What is repository? How is it helpful to the data warehouse maintenance?
4 Explain the following strategies for Data Warehouse testing
- Completeness testing
- Data transformation testing