O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

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

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. ...

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