Separating Single Field to Values

I have a table having column col1, col2. If for a col1 there is some data in col2.
EX: Col1=0012 and Col2 = 12,13,14
then i need these three values 12, 13,14 separately not as a single string as it is in table. Or you can say in need to separate these three values after it is returned by query.There may be only one value or more than 3 as well.
EX: 12,13,14,15.........

Nishant garg
Profile Answers by Nishant garg Questions by Nishant garg
Oct 18th, 2011
4
6872

Questions by Nishant garg

Informatica

Answer

Showing Answers 1 - 4 of 4 Answers

sunilkumar

Oct 23rd, 2011

I think u can achieve the above requirement by using transaction control transformation.

vizaik
Profile Answers by vizaik

Oct 25th, 2011

Can be done by using java transformation with the below like code:

StringTokenizer st = new StringTokenizer(col2, ",");
while(st.hasMoreTokens()) {
O_col2 = st.nextToken();
generateRow();
}