SQL Server Integration Services: Difference between revisions

Revision as of 13:47, 5 November 2014

Revision as of 14:22, 5 November 2014

Line 36:

===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 | accessdate = 22 March 2013}}</ref>

{| class="wikitable"

|-

| Aggregation || LookupExport and& FuzzyImport LookupColumn || [[Pivot table|Pivot]]

|-

| Audit || OLEFor DBloop CommandContainer || Row Count

|-

| 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> || PartitionForeach ProcessingLoop Container || Row Sampling

|-

| Copy/Map || (Fuzzy) Lookup || Script Component

| 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>

|-

| Data Conversion || Row[[Fuzzy Samplinglogic|Fuzzy]] TransformationGrouping || [[Slowly Changing Dimension]]

|-

| Data Mining Model Training || OLE DB Command || [[Pivotterm tableextraction|PivotTerm Extraction]] & Unpivot

|-

| Data Mining Query || RowPartition CountProcessing || Term Lookup

|-

| Copy/MapDerived 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 | accessdate = 22 March 2013}}</ref> || [[Pivot table|Unpivot]]

| Derived Column || Row Sampling

|-

| Dimension Processing || ScriptRow Sampling Transformation || Component

|-

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

|-

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

|-

| Foreach Loop Container || Term Lookup

|-

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

|}