.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Transformation Categorized in SSIS - SQL Server Integration Services (SSIS) - Part 54

Posted By:Karthikeyan Anbarasan       Posted Date: May 14, 2011    Points: 200    Category: DataBase    URL: http://www.dotnetspark.com  

In this article we are going to see on the different transformation on how they are categorized to use it across the SQL Server Integration Services (SSIS) package



This article is about various transformations and how they are categorized to be used across the package. This categorization is based on the usage of the transformation and the process of how it can be used across the package. The brief description of each of the transformations are available in my previous articles. 

You can also read my other articles on SSIS from Here

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


So in this article we have seen the various transformations and the subcategories of each section.
 Subscribe to Articles


Further Readings:


No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend