Today i will cover "CHARACTER MAP" Transformation.
In this post i will cover,
Character map transformation is one of basic and less use transformation ,present in Data Flow Tool Box.
Character Mapping will convert string format into required format (UPPER CASE, lower case, Full width, Half width..).
Character map transformation look like below in Data Flow Tool Box
By using character Mapping we can do following operations .
How to use Character Map transformation:
First add "DATA FLOW TASK" in "CONTROL FLOW".
Then, double click on "Data Flow" Task, Now you are in "Data Flow" Designer Tab.
Drag "Character Map" Transformation from the available transformations into "Data Flow" designer.
Right click on "Character Map" and select "Edit" to view available operations.
After Clicking "Edit", it shows available columns, from these select one column to perform operation.
After selecting column, we can select "New column" or "In-Place Change" under "Destination".
Click on "Operation", it shows list of available operations what we can perform. Here i selected "UPPER CASE" operation ( it converts all case into UPPER CASE)..
Connect this transform to destination or another transform. Here i connected to sort transformation and added "Data viewer" to view the output.
Execute the package. And here is the required output.
In this post i will cover,
- what is Character mapping?
- how to use character mapping?
- why to use character mapping?
- what are the types of conversions we can do using "Character Map" transformation?
Character map transformation is one of basic and less use transformation ,present in Data Flow Tool Box.
Character Mapping will convert string format into required format (UPPER CASE, lower case, Full width, Half width..).
Character map transformation look like below in Data Flow Tool Box
How to use Character Map transformation:
First add "DATA FLOW TASK" in "CONTROL FLOW".
Then, double click on "Data Flow" Task, Now you are in "Data Flow" Designer Tab.
Drag "Character Map" Transformation from the available transformations into "Data Flow" designer.
After Clicking "Edit", it shows available columns, from these select one column to perform operation.
After selecting column, we can select "New column" or "In-Place Change" under "Destination".
Click on "Operation", it shows list of available operations what we can perform. Here i selected "UPPER CASE" operation ( it converts all case into UPPER CASE)..
No comments:
Post a Comment