Tuesday 19 August 2014

Transformations in SSIS

1. Fuzzy Grouping
2. Lookup and Fuzzy Lookup
3. Percentage Sampling[2] and Row Sampling Transformation.
4. Copy/Map, Data Conversion, and Derived Column
5. Aggregation
6. Data Mining Model Training, Data Mining Query, Partition Processing, and Dimension 
7. 7Processing
8. Pivot and Unpivot
9 .Slowly Changing Dimension(ACD)
10. Script Component
11. Audit
12. Cache Transform[3]
13. Export and Import Column
14. OLE DB Command
15.  Row Count
16. Term Extraction
17. Term Lookup
18. Row Sampling
19. Foreach Loop Container
20. For loop Container

The Conditional Split transformation is used to conditionally route rows to other transformation objects based on a particular condition. It is similar to the "if..else" construct in the C language.

No comments:

Post a Comment