Please help in this scenario...
Target should be like below..
You can take the below transformations then you can load
If you are sure that you will have only 3 values else you need to take those many variable ports in expression transformation
1.expression->var1,var2 and var3 ports
2.store the values by having below expression
SUBSTR( Desctiption,1,INSTR( Description,',' ,-1,1 ) - 1 )
You need to use the above expression to get each value seperated by a Comma in column desctiption.
group 1: if var1 value is not null
group 2:if var2 value is not null
group 3:if Var3 value is not null
4. Take 3 Target objects
load the data from Router to Target.
Thanks and regards
Make a new output port in expression as below
description_out =replacechr(1,description, Chr(44),chr(10))
Try it out.. hope it will work
PS: chr(44) means comma(,) and chr(10) means newline.
Following example should help you.
In addition to this, you will also find over 100 mapping samples on Informatica Marketplace website.