Copy column
and derive column transformation are used to add a new column.
Copy column
can add new columns only through existing columns
But derived
column it can add new columns without any help from existing columns.
We can add
the same column as copy column transformation as well as we can add new column
which is not exist on the input and we can assign the new column values as per
our requirement. For example
Here I am
creating Full name, for full name I have concatenate the (First name, mid name
and Last name). We can’t achieve this
using Copy column.
In drive
column transformation we are using expression (for manipulating the input column
like data conversion, combine the column etc.)
Copy column
doesn't support Error Output.
Derive
column transformation support Error Output.
No comments:
Post a Comment
If you have any doubt, please let me know.