Informatica: Breaking raws into multiple raws based on the values in a field?

Question

My source data

id    |   value
10       a,b,c
20       d,e,f

I want output is

id    |   value
10       a
10       b
10       c
20       d
20       e
20       f

How to do this scenario

Answer 1

you can try java transformation.

Exp 
=== 

id(I/O-String) 
value(I/O-String) 
value_var(V-String) = REPLACECHR( 0, value, ',', NULL ) 
value_len_var(V-Integer) = length(value_var) 
value_out(O-String) = value_var 
value_len(O-Integer) = value_len_var 

Connect id, value_out and value_len to java transformation and put the following code in the Java code tab and compile it.

if (!isNull("value_out")) 
{ 
  int len = value_len; 
  String str = value_out; 
  for (int i=0; i<len; i ) 
  { 
    value_out = str.substring(i,i 1); 
    generateRow(); 
  } 
} 

Comments

Thank you very much Salil Agarwal