Row to Column

[cme_prak]

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

[markdanny]

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

[markdanny]

u can achive this by using a router and two joiners

[cme_prak]

Hi Mark,

I finished that scenerio, using one expression and the aggregator.

Thx
Prakash