Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Katie and Emil

We are Katie & Emil and together we have decided to learn more & more on how to build data warehouses using Microsoft products. The best option to learn is to teach so we write tutorials and share it with others.

SSIS aggregate transformation

In this SSIS 2012 tutorial we will show you how to use data flow Aggregate Transformation and we will use our example of Customer and Total Sales Amount which is an interesting example as often to get more insight into customer behaviour it is useful to slice and dice the data by Customer Total Spend (usually spend band not exact figure). Aggregate transformation allows us to do that but remember if you can use group by at source and your query is relatively simple than usually that is a better option. This tutorial is now part of our SSIS Tutorial and in the future will be part of exam guide 70-463 implementing a data warehouse using SQL Server 2012.

Comments

Leave a comment on the original post [www.katieandemil.com, opens in a new window]

Loading comments...