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 ...
Get Exam Ref 70-767 Implementing a SQL Data Warehouse 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.
