Informatica Doubt

[nikhilboorla]

This is interview question from ness technologies....

my source is id , name

                     1,  praveen*kumar

                      2,  siddu/don

 

 tgt is id , name
          1,praveen
          1,kumar
          2,siddu
           2, don

[jaffanajeffada]

first split the name using an expression then use a normalizer transformation, to make the repetitive columns to multiple rows!