Extract Transform Load (ETL)

Extract Transform Load (ETL)

ETL stands for Extract, Transform and Load, which are phases of data processing in a data warehouse.

Extract
In this phase, data is read from the source systems, and copied to the staging area of the data warehouse - in a Microsoft environment, it typically means copying data from various sources with SQL Server Integration Services ([[articles:SQL Server Integration Services|SSIS]]) to one or more staging databases in SQL Server. The most common data source formats are relational databases and flat files.

Transform
In the Transform phase, the data in the staging area is transformed: the data is validated and cleansed, then data from different sources are joined and consolidated following business rules. A massive amount of calculations and aggregations are executed on the data, to prepare the next phase. The values of derived measures are calculated here. For the list of the built-in transformations in SSIS, please check the article: SSIS: List of transformations.

Load
In the Load phase, the data warehouse processes move data in its end target, usually the presentation area of the data warehouse. Feedback about the results is sent to other applications or to end users. The presentation area is where end users can access the data directly, through web reports, OLAP interfaces or other BI applications.
Leave a Comment
  • Please add 8 and 7 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Zoltán Horváth edited Revision 2. Comment: added SSIS and transformation list link

Page 1 of 1 (1 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • correcting tags

  • Zoltán Horváth edited Revision 2. Comment: added SSIS and transformation list link

  • Great article, Zoltan!

  • Thanks :)

  • Zoltán Horváth edited Revision 7. Comment: trying to fix a wiki link issue

  • This article needs more information and also See Also section

Page 1 of 1 (6 items)