Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (1Microsoft Partner, Microsoft Community Contributo)
  • When: 29 Aug 2011 12:38 PM
  • Last revision by (eMicrosoft Partne)
  • When: 16 Sep 2013 10:06 AM
  • Revisions: 10
  • Comments: 6
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  Extract Transform Load (ETL)

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.
, , , , , , , , , , [Edit tags]
Leave a Comment
  • Please add 6 and 7 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 13 Jan 2012 5:21 AM

    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
  • Posted by
    on 13 Jan 2012 4:11 AM

    correcting tags

  • Posted by
    on 13 Jan 2012 5:21 AM

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

  • Posted by
    on 26 Jan 2012 1:36 PM

    Great article, Zoltan!

  • Posted by
    on 19 Mar 2013 5:00 PM

    Thanks :)

  • Posted by
    on 16 Sep 2013 9:41 AM

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

  • Posted by
    on 16 Sep 2013 10:06 AM

    This article needs more information and also See Also section

Page 1 of 1 (6 items)