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?
- 2 Answers
- 6636 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Explain the pipeline partition with real time example?
can you please explain me pre session and post session options?
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
What are the components of the workflow manager?
What all are steps in up gradation of Informatica server?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is Cognos script editor?
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
can we see default group,when we use router?if yes how?
Why union transformation is an active transformation?
How to import oracle sequence into Informatica?
Teradata 
