Adding Data Transformations
The sample package CalculatedColumns.dtsx shows examples of the Aggregate, Derived Column, and Sort data flow transformations. The Aggregate transform allows you to easily perform aggregations of types GroupBy, Count, Count Distinct, Sum, Average, Minimum, or Maximum against your data flow by simply configuring the aggregate dialog box. The Data Flow work area for the Calculated Columns SSIS sample package is shown in Figure 8–28.
The “Add transformation” group contains some of the data flow transformation types that are most often used in BI projects: Copy Column, Import Column, and Union All. All of these transformations are self-explanatory.
The transformation group also contains the Merge and Merge Join transformations. ...
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition 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.
