Chapter 4. ETL with Integration Services
As you learned in Chapter 1, Data Warehouse Design, a data warehouse is an integrated database with a specific design, which helps us in data analysis and reporting. Chapter 1, Data Warehouse Design was about designing the data warehouse. However, there is always another step, that is, loading the data into the data warehouse. This requirement brings another component of the data warehousing system into play, which is Extract, Transform, and Load (ETL). The following list explains the function of each process:
- Extract: This is the process of fetching data from the source systems
- Transform: This is the process in which we apply transformations such as aggregation, joining with other datasets, applying rules, ...
Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
