SRC->SQ->SRT->AGT->TGT SRT - SORT BY ID. AGT-GROUP BY ID.

in source one table is there.

id value
--- ------
1 a
2 b
3 c
1 d
2 e
1 f

in target i want

id value
---- ------
1 a,d,f
2 b,e
3 f

How to implement it in informatica without using normalizer
transformation?

Question Posted / babu

2 Answers
7214 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / babu

SRC->SQ->SRT->AGT->TGT

SRT - SORT BY ID.
AGT-GROUP BY ID.
EXP - ID
NAME
*** ( V--> FOR VARIABLE PORT ,O-->FOR OUTPUT PORT)

V_NAME=IIF(V_ID=ID,V_NAME||','||NAME,NAME)
V_ID=ID

O_ID=V_ID
O_NAME=V_NAME

Is This Answer Correct ?

1 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Differentiate between router and filter transformation?

1019

Why update strategy and union transformations are active?

1051

Explain lookup transformation source types in informatica

1107

What is union transformation?

971

How would you copy the content of one repository to another repository?

1027

What is primary and backup node?

1137

Explain constraint based loading in informatica

1103

Can you use flat files in Mapplets.

2660

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2015

can anyone suggest best free Talend data integration training online

1698

Is there any target staging area in informatica not staging area

2582

What is main use of mapplet?

1139

wat are deployement groups in informatica, how it will be used for developers

1728

What are session parameters ? How do you set them?

1857

Is it possible to revert a global repository to local one and why?

1088