Content deleted Content added
m added Category:2005 software using HotCat |
→Features of the data flow task: This seemed like a list, not a table. The colums did not have headers, and the rows and columns did not appear to have any noticeable relations. Therefore replaced table with a list. |
||
Line 37:
===Features of the data flow task===
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 | access-date = 22 March 2013}}</ref>
{{Div col|colwidth=18em}}
* Aggregation
* Audit
| Audit || For loop Container || Row Count▼
* Copy/Map
* Data Conversion
▲| Cache Transform<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> || Foreach Loop Container || Row Sampling
* Data Mining Model Training
* Data Mining Query
| Copy/Map || ([[Fuzzy_logic|Fuzzy]]) Lookup || Script Component▼
* Dimension Processing
* Derived Column
* Export & Import Column
* Foreach Loop Container
* [[Fuzzy_logic|Fuzzy]] Grouping
* OLE DB Command
| Derived Column || 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 | access-date = 22 March 2013}}</ref> || [[Pivot table|Unpivot]]▼
* Partition Processing
▲
| Dimension Processing || Row Sampling Transformation || ▼
* [[Pivot table|Pivot]]
* [[Pivot table|Unpivot]]
* Row Count
* Row Sampling
* Script Component
* [[Slowly Changing Dimension]]
* [[Term extraction]]
* Term Lookup
{{div col end}}
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>[[conditional (programming)|if … else]]</code>" construct in the C language.
| |||