Overview
Extraction, Transformation and Load (ETL) process definition for feeding a data warehouse. This can be done using standard ETL tools or using a service oriented architecture.
Benefits
1. Brining in data from Line of Business (LOB) application
2. Check data for correctness and completeness
Approach
1. Understand data sources and formats
2. Write ETL Jobs to fetch data
3. Write Validations
4. Push data into warehouse