Kimball s Bus

ETL: A Closer Look

• Extracting:
• Transfer data to the warehouse
• Transforming:
• Integrates many sources together
• Possibly cleansing: inconsistencies, duplication, missing values, etc..
• Possibly producing diagnostic metadata
• Loading:
• Structuring and loading the data into the dimensional data model