Mapping : Split The String Dynamically Using JTX

Name of Solution:
Mapping: Split delimited string into Columns
Business Requirement:
Reusable Java transformation to split a delimited string into multiple column.
Solution URL:
https://community.informatica.com/solutions/2795
Supported Versions:
PowerCenter 9.1 and above
Description:
Overview:
Into many real-time projects, we get the values in a single port which are delimited using a
character constant. We need to split these values and populate multiple columns.
Solution:
This mapping example, that you download here illustrates how to use the java
transformation to split a delimited column into multiple columns. The input and output of
the Java transformation are,
Input:
Output:
Example:
Input Row:
Output Row:
Note: In this mapping example, we have configured the JTX to split into maximum of ten
columns.
Download file contents:
1. Workflow
2. Source File
Steps to implement the solution:
1. Place source file in $PMSourceFileDir
“Deleimeted_vals.txt”.
folder
and
observe
the
source
file
2. Import workflow using the Repository Manager. Select the appropriate folder from
the repository and resolve the conflicts by choosing suitable option.
3. In the PowerCenter Designer, open the Java transformation “jtx_split_string”
4. Open the workflow in Workflow Manager. Assign the integration service in Workflow > Edit -> Integration Service
5. Edit session and assign valid connection object for the source and target.
6. For more details of importing object, please visit our YouTube link.
7. Execute the workflow and observe the target files.
YouTube Video on Importing and Configuring Workflows:
http://www.youtube.com/playlist?list=PLLRreK2jjjgWBQ4NPfp0QWTxYDvlnEqSJ
Other Useful links:
Mapping Bundles
Workflow Bundles
Informatica Tools Bundles
Informatica for Social Media Bundles
Debugging Tools Bundles
Visio Templates Bundles
B2B Templates and Projects Bundles
Data Quality Packs and Plans Bundles
Script Bundles

Download Report