O'Reilly logo

Exam Ref 70-767 Implementing a SQL Data Warehouse by Raj Uchhana, Jose Chinchilla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2 Extract, transform, and load data

You may know SSIS stands for SQL Server Integration Services, but what does integration mean? Integration means to combine or bring together, and in this instance, it means bringing all of the data together from various sources. In a nutshell, SSIS provides the orchestration to move data from source to destination (OLTP > DW), as well as transform and cleanse the data (replacing null values or correcting misspelled city names in a table).

What makes SISS powerful is its ability to move and transform data from various sources to various destinations. For example, SSIS can be used to extract financial data from an Oracle database and import it into a SQL Server database. You can also extract sales data ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required