in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d

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 / ranjan

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

Answers were Sorted based on User's Feedback

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in targe..

Answer / siddu

SOURCE->SRT->EXP->TGT

SRT - Sort by column col1.
EXP - col1
col2
v_col2=iif(v_col1=col1,v_col2||','||col2,col2)
v_col1=col1
o_col1=v_col1
o_col2=v_col2

Is This Answer Correct ?

12 Yes

2 No

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in targe..

Answer / 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

More Informatica Interview Questions

How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers TCS, Tech Mahindra,

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers Informatica,

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers IBM,

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers iGate,

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

0 Answers IBM,

What will be the approach?

0 Answers

Difference between STOP & ABORT in Informatica.

3 Answers Accenture, Wells Fargo,

What is InformaticaPowerCenter?

0 Answers Informatica,

Why we select the table which has minimum number of records as Master table in joiner?

4 Answers HG, UST,

How can we remove the duplicates from flat file source?

0 Answers

How to load the data from people soft hrm to people soft erm using informatica?

0 Answers

What are the components of workflow manager?

0 Answers

For more Informatica Interview Questions Click Here