SQL Server Integration Services: Difference between revisions

Content deleted Content added
No edit summary
Line 41:
* Aggregation
* Audit
* Cache Transformtransform<ref>{{cite web | url = http://msdn.microsoft.com/en-us/library/bb895264 | title = Cache Transform|work=Microsoft Developer Network | publisher = Microsoft | access-date = 22 March 2013}}</ref>
* Copy/Map
* Data Conversionconversion
* Data Miningmining Modelmodel Trainingtraining
* Data Miningmining Queryquery
* Dimension Processingprocessing
* [[Derived Columncolumn]]
* Export &and Importimport Columncolumn
* For loop Containercontainer
* Foreach Looploop Containercontainer
* ([[Fuzzy_logic|Fuzzy]]) Lookuplookup
* [[Fuzzy_logic|Fuzzy]] Groupinggrouping
* OLE DB Commandcommand
* Partition Processingprocessing
* Percentage Samplingsampling<ref>{{cite web | url = http://msdn.microsoft.com/en-us/library/ms139864.aspx | title = Percentage Sampling Transformation|work=Microsoft Developer Network | publisher = Microsoft | access-date = 22 March 2013}}</ref>
* [[Pivot table|Pivot]]
* [[Pivot table|Unpivot]]
* Row Countcount
* Row Samplingsampling
* Row Samplingsampling Transformationtransformation
* Script Componentcomponent
* [[Slowly Changingchanging Dimensiondimension]]
* [[Term extraction]]
* Term Lookup
{{div col end}}
 
The Conditionalconditional Splitcplit transformation is used to conditionally route rows to other transformation objects based on a particular condition. It is similar to the "<code>[[conditional (programming)|if … else]]</code>" construct in the C language.
 
=={{Anchor|A-tools}}Other included tools==