SQL Server Integration Services: Difference between revisions

Revision as of 13:41, 5 November 2014

Revision as of 13:47, 5 November 2014

Line 37:

SSIS provides the following built-in transformations:<ref>{{cite web | title = Integration Services Transformations | url = http://msdn.microsoft.com/en-us/library/ms141713.aspx|work=Microsoft Developer Network | publisher = Microsoft | accessdate = 22 March 2013}}</ref>

{| class="wikitable"

* Aggregation

|-

* Audit

*| Aggregation || Lookup and [[Fuzzy logic|Fuzzy]] Lookup

* Cache Transform<ref>{{cite web | url = http://msdn.microsoft.com/en-us/library/bb895264 | title = Cache Transform|work=Microsoft Developer Network | publisher = Microsoft | accessdate = 22 March 2013}}</ref>

|-

* Copy/Map

*| Audit || OLE DB Command

* Data Conversion

|-

* Data Mining Model Training

*| Cache Transform<ref>{{cite web | url = http://msdn.microsoft.com/en-us/library/bb895264 | title = Cache Transform|work=Microsoft Developer Network | publisher = Microsoft | accessdate = 22 March 2013}}</ref> || Partition Processing

* Data Mining Query

|-

* Derived Column

*| Copy/Map || Percentage Sampling<ref>{{cite web | url = http://msdn.microsoft.com/en-us/library/ms139864.aspx | title = Percentage Sampling Transformation|work=Microsoft Developer Network | publisher = Microsoft | accessdate = 22 March 2013}}</ref> and Row Sampling Transformation.

* Dimension Processing

|-

* Export and Import Column

| Data Conversion || Row Sampling Transformation

* For loop Container

|-

* Foreach Loop Container

*| Data Mining Model Training || [[Pivot table|Pivot]] and& Unpivot

* Fuzzy Grouping

|-

* Lookup and [[Fuzzy logic|Fuzzy]] Lookup

*| Data Mining ModelQuery Training|| Row Count

* OLE DB Command

|-

* Partition Processing

*| Derived Column || Row Sampling

* Percentage Sampling<ref>{{cite web | url = http://msdn.microsoft.com/en-us/library/ms139864.aspx | title = Percentage Sampling Transformation|work=Microsoft Developer Network | publisher = Microsoft | accessdate = 22 March 2013}}</ref> and Row Sampling Transformation.

|-

* [[Pivot table|Pivot]] and Unpivot

*| Dimension Processing || Script Component

* Row Count

|-

* Row Sampling

*| Export & Import Column || [[Slowly Changing Dimension]]

* Script Component

|-

* [[Slowly Changing Dimension]]

*| For loop Container || [[term extraction|Term Extraction]]

|-

* Term Lookup

*| Foreach Loop Container || Term Lookup

|-

*| [[Fuzzy logic|Fuzzy]] Grouping ||

|}

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