From the course: SQL Server Integration Services
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Understand transformations - SQL Server Tutorial
From the course: SQL Server Integration Services
Understand transformations
- [Instructor] Transformations provide the bulk of the activities performed in a data flow. Retrieving records from a source and writing data with a destination are comparably straightforward. Transformations are where the power of the data flow lies. There are five general categories of transformations that you can add in Integration Services. Business Intelligence Transformations clean data, mine text, and run prediction queries. These can perform fuzzy matching across columns and can determine if records that contain data that is close should be consolidated into a single canonical row. Row Transformations update column values and create new columns, then applies changes to every row in the input data. Rowset Transformations create new rows by applying aggregate calculations, sampling, sorting, and pivoting. Split and Join Transformations distribute rows to different outputs, or merge multiple sources into a single data set. And finally, we have Auditing Transformations, which…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
(Locked)
Data flow components1m 49s
-
(Locked)
Extracting data from a source5m 43s
-
(Locked)
Understand transformations1m 15s
-
(Locked)
Character Map row transformation3m 50s
-
(Locked)
Conditional Split transformation5m 3s
-
(Locked)
Rowset transformations2m 25s
-
(Locked)
Loading data to a destination5m 37s
-
(Locked)
Prevent duplicate records2m 52s
-
(Locked)
-
-
-