| S No | Transformation | Description |
| 1 | Aggregate | Summing / Averaging a total of the products purchased by a customer online to produce the final amount. |
| 2 | Audit | When you want to load audit information like (Created Date, UserName , server Name..etc) to your Destination table. |
| 3 | Character Map | String Manipulation, like Lowercase, Uppercase etc.. |
| 4 | Conditional Split | When you want to split your data to many destinations based on conditions. |
| 5 | Copy Column | To have same column data with alias name |
| 6 | Data Conversion | To convert the data type, (Unicode String àString…) |
| 7 | Data Mining Query | Evaluating the input data against the analysis model to get a proper set. |
| 8 | Derived Column | Adding a title of courtesy (Mr., Mrs., Dr, etc) before the name and removing the trailing and ending spaces. |
| 9 | Export Column | When we get the normal files/pdf files/image files from different systems and save it under a particular folder and map it to the table master |
| 10 | Fuzzy Grouping | Matching the name of a customer with master and child table and use it to group and get the desired set |
| 11 | Fuzzy Lookup | Matching the name of a customer with master and child table and use it to group and get the desired set |
| 12 | Import Column | When we get the normal files/pdf files/image files from different systems and save it under a particular folder and map it to the table master |
| 13 | Lookup | Employee table information saved in a master file and the region wise data available across the table which can be mapped and joined to perform a joined querying operation |
| 14 | Merge | Combine data from multiple data source like master and child employee table and get result in single dataset. |
| 15 | Merge Join | Combine data from multiple data source like master and child employee table and get result in single dataset. Can use any type of join like inner, outer, left , right etc |
| 16 | Multicast | Similar to the conditional split but this splits across all the parts |
| 17 | OLE DB Command | Used when we need to do updates to all the rows of a table like update If a message sent to the entire customer who have made a payment today. |
| 18 | Percentage Sampling | Similar to “SELECT TOP 10 PERCENT” in TSQL |
| 19 | Pivot | To Convert Rows to Column and Column to Rows |
| 20 | Row Count | Gives the Count of Rows |
| 21 | Row Sampling | Similar to “SELECT TOP 10 ” in TSQL |
| 22 | Script Component | Used for places where we need to use .net framework specific assemblies. |
| 23 | Slowly Changing Dimension | When we need to use some historic dimensions of data |
| 24 | Sort | To make some sorting to get the desired result. Sorting like customer who made the highest payment in a particular day. |
| 25 | Term Extraction | Used to get a data from a large set of data and get the extracted output in a formatted set. |
| 26 | Term Lookup | Used to get a data from a large set of data and get the extracted output in a formatted set. |
| 27 | Union All | Used to get data from different data sources and get in a single dimensional format. |
| 28 | Unpivot | Reverse of PIVOT Operation |