Click here to Skip to main content
15,868,164 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
We have two transformation to convert datatype so please tell me with scenario so i can understand clearly what it is exactly?

What I have tried:

We have two transformation to convert datatype so please tell me with scenario so i can understand clearly what it is exactly?
'

any answer would be greatly appreciated...
Posted
Updated 26-Apr-16 23:44pm

1 solution

The purpose of Data conversion is to do just data conversion.

While Derived column task is used for most of the transformations. To achieve this, data conversion is also put in as a part of it. If you are just intending to do data conversion and no other transform, for simplicity and readability of the package.

Data conversion gives a simple UI to the end user for full filling the requirement of changing the data type of incoming columns.

Derived columns also can help us to achieve data conversion but there we have to explicitly write a code to type cast that.
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900