First page Back Continue Last page Overview Graphics
The ETL Design Pattern
Extract from the source
Transform
- Get codes, dates, values all consistent
- “Conform” the Entities
- Create a dimension with only unique entities
- Create simple references from fact to dimension
- Beyond our scope is the Slowly-Changing Dimension problem.
Load
- Entities into Dimension tables
- Facts into Fact tables
Once this is complete, we can do our analysis and reporting