Printable View
Hi all, src ---- id colname colval -- --------- -------- 1 name prakash 1 age 24 1 sal 350000 2 name srini 2 sal 25000 tgt ---- id name age sal 1 prakash 24 35000 2 srini 25000 the above mentioned is my scenerio. How to solve this scenrio? thx prakash :)
In Informatica:
step1:Use Router Trans to group based on colname, you will get 3 groups
1.colname='name'
2.colname='age'
3.colname='sal'
step2:3 Exp Trans after router, collect id and colval from each group
step3: use two joiners to collect the record on id(use sorted i/p to joiners)
This logic drops records if any of the fields is missing(name,age,sal)
Fell free to post comments on this reply
u can achive this by using a router and two joiners
Hi Mark,
I finished that scenerio, using one expression and the aggregator.
Thx
Prakash:)