Tuesday, March 19, 2013
Informatica Realtime Scenorio
Suppose the source table has values like this
And the target should be
How will you do the mapping?
Answer: This can be done using an expression transf and Aggregator transf.
In expression transf declare 2 variables ID_V and NAME_V
IIF(ID_V=ID,NAME_V ‘ * ‘ NAME,NAME)
NOW pass the output ports to aggregator GROUP BY ID and connect to target.