This is part 54 of the series of article on SSIS

Introduction:

In this article we are going to see on the different transformation on how they are categorized to use it across the package. This categorization is based on the usage of the transformation and the process on how it can be used across. The brief description of each of the transformations are available in my previous articles.

You can look into my series of article on SSIS at the url – https://f5debug.net/tutorial/ssis.php

We can partition the transformation into 7 types as shown below

1. Row Transformations
2. Rowset Transformations
3. Split and Join Transformations
4. Quality Transformations
5. Mining Transformations
6. Synchronous and Asynchronous Transformations
7. Other Transformations

Now these transformations are further sub categorized as below

Row Transformations – Used to update column values and is applied to each row in the input dataset.

• Character Map
• Copy Column
• Data Conversion
• Derived Column
• Script Component
• OLE DB Command

Rowset Transformations – Used to create a new Rowset

• Aggregate
• Sort
• Percentage Sampling
• Row Sampling
• Pivot
• Unpivot

Split and Join Transformations – Used to distribute rows to different outputs, create copies of the transformation inputs

• Conditional Split
• Multicast
• Merge
• Merge Join
• Union All
• Lookup

Data Quality Transformations – Used to perform data quality operations

• Fuzzy Lookup
• Fuzzy Grouping

Data-Mining Transformations – Used to perform data-mining operations

• Data-Mining Query
• Term Extraction
• Term Lookup

Synchronous and Asynchronous Transformations – Used to determine how rows are processed.

• Synchronous transformations
• Asynchronous transformations
• Partially blocking transformations
• Blocking transformations

Other Transformations – Some extra transformations

• Export Column
• Import Column
• Audit
• Row Count
• Slowly Changing Dimension

Conclusion:

So in this article we have seen on the different transformation and the subcategories of each section