SQL Server Integration Services: Difference between revisions

Revision as of 21:02, 20 July 2012

Revision as of 11:40, 10 August 2012

Line 26:

* Conditional Split

* Multicast

* Union-All, Merge, and [[Sort-merge join|Merge Join]]

* Sort

* Fuzzy Grouping

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

* Percentage Sampling<ref>[http://msdn.microsoft.com/en-us/library/ms139864.aspx creates a sample data set by selecting a percentage of the transformation input]</ref> and Row Sampling Transformation.

* Copy/Map, Data Conversion, and Derived Column

* Aggregation

* Data Mining Model Training, Data Mining Query, Partition Processing, and Dimension Processing

* [[Pivot]] and Unpivot

* [[Slowly Changing Dimension]]

* Script Component

* Audit

* Cache Transform<ref>[http://msdn.microsoft.com/en-us/library/bb895264 writes data from a connected data source in the data flow to a Cache connection manager]</ref>

* Cache Transform

* Export and Import Column

* OLE DB Command

* Row Count

* [[term extraction|Term Extraction]]

* Term Lookup

* Row Sampling