SSIS Question
What are the different row transformations in SSIS?

Question

SSIS Question

What are the different row transformations in SSIS?

Accepted Answer

Character Map Transformation: The Character Map transformation allows you to do character operations on string columns. It makes common string data changes for you.
Copy Column Transformation: This transformation is used to add a copy of column to the transformation output. You can later transform the copy. Makes a copy of a single or multiple columns that will be further transformed by subsequent tasks in the package
Data Conversion Transformation: This transformation is used to convert a column data type to a new (another) column data type.
Derived Column Transformation: This transformation is used to apply expression to a data column and create a new derived column calculated from an expression.
OLEDB Command Transformation: Runs a SQL command for each input data row. Normally your SQL statement will include a parameter (denoted by the question mark)
Script Component Transformation: This transformation is used to do a custom transformation. It uses a script to transform the data and you can apply specialized business logic to your data flow.

Top PolicyBazaar Senior Database Developer interview questions & answers

Popular interview questions of Senior Database Developer