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
7201 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 many data models u have done in informatica project?

2 Answers TCS,

How do you change parameter when you move it from development to production.

1 Answers

Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers IBM,

followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200

2 Answers Oracle,

What is aggregate cache in aggregator transformation?

0 Answers Informatica,

IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

5 Answers Wipro,

What does reusable transformation mean?

0 Answers

explain different levels in pushdown optimization with example?

2 Answers TCS,

What are Dimensional table?

0 Answers Informatica,

What is option by which we can run all the sessions in a batch simultaneously?

0 Answers Informatica,

What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

2 Answers IBM, Wipro,

For more Informatica Interview Questions Click Here