What Are The Transformations Available In Ssis?

1.	What Are The Transformations Available In Ssis?
Answer» AGGEGATE - It applies aggregate functions to Record Sets to produce new output records from aggregated values. AUDIT - Adds Package and Task level Metadata - such as Machine Name, Execution Instance, Package Name, Package ID, etc. CHARACTER MAP - Performs SQL Server level makes string data changes such as changing data from LOWER case to upper case. CONDITIONAL SPLIT – Separates available input into separate output pipelines based on Boolean Expressions CONFIGURED for each output. COPY COLUMN - Add a copy of column to the output we can later transform the copy keeping the ORIGINAL for auditing. DATA CONVERSION - Converts columns data types from one to another type. It stands for Explicit Column Conversion. *DATA MINING QUERY* – Used to perform data mining query against analysis services and manage Predictions Graphs and Controls. *DERIVED COLUMN* - Create a new (computed) column from given expressions. *EXPORT COLUMN* – Used to export a Image specific column from the database to a flat file. *FUZZY GROUPING* – Used for data cleansing by finding rows that are likely duplicates. FUZZY LOOKUP - Used for Pattern Matching and Ranking based on fuzzy logic. *IMPORT COLUMN* - Reads image specific column from database onto a flat file. *LOOKUP* - Performs the lookup (searching) of a given reference object set against a data source. It is used for EXACT matches only. *MERGE* - Merges two sorted data sets into a single data set into a single data flow. MERGE JOIN - Merges two data sets into a single dataset using a join junction. *MULTI CAST* - Sends a copy of supplied Data Source onto multiple Destinations. ROW COUNT - Stores the resulting row count from the data flow / transformation into a variable. ROW SAMPLING - Captures sample data by using a row count of the total rows in dataflow specified by rows or percentage. UNION ALL - Merge multiple data sets into a single dataset. *PIVOT* – Used for Normalization of data sources to reduce analomolies by converting rows into columns UNPIVOT – Used for demoralizing the data structure by converts columns into rows incase of building Data Warehouses.

Answer»

AGGEGATE - It applies aggregate functions to Record Sets to produce new output records from aggregated values.
AUDIT - Adds Package and Task level Metadata - such as Machine Name, Execution Instance, Package Name, Package ID, etc.
CHARACTER MAP - Performs SQL Server level makes string data changes such as changing data from LOWER case to upper case.
CONDITIONAL SPLIT – Separates available input into separate output pipelines based on Boolean Expressions CONFIGURED for each output.
COPY COLUMN - Add a copy of column to the output we can later transform the copy keeping the ORIGINAL for auditing.
DATA CONVERSION - Converts columns data types from one to another type. It stands for Explicit Column Conversion.
DATA MINING QUERY – Used to perform data mining query against analysis services and manage Predictions Graphs and Controls.
DERIVED COLUMN - Create a new (computed) column from given expressions.
EXPORT COLUMN – Used to export a Image specific column from the database to a flat file.
FUZZY GROUPING – Used for data cleansing by finding rows that are likely duplicates.
FUZZY LOOKUP - Used for Pattern Matching and Ranking based on fuzzy logic.
IMPORT COLUMN - Reads image specific column from database onto a flat file.
LOOKUP - Performs the lookup (searching) of a given reference object set against a data source. It is used for EXACT matches only.
MERGE - Merges two sorted data sets into a single data set into a single data flow.
MERGE JOIN - Merges two data sets into a single dataset using a join junction.
MULTI CAST - Sends a copy of supplied Data Source onto multiple Destinations.
ROW COUNT - Stores the resulting row count from the data flow / transformation into a variable.
ROW SAMPLING - Captures sample data by using a row count of the total rows in dataflow specified by rows or percentage.
UNION ALL - Merge multiple data sets into a single dataset.
PIVOT – Used for Normalization of data sources to reduce analomolies by converting rows into columns
UNPIVOT – Used for demoralizing the data structure by converts columns into rows incase of building Data Warehouses.

What Are The Transformations Available In Ssis?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment