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?
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 |
what is metadata?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
what is the difference between Informatica7.1 & informatica 8.1
difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?
How do you handle two sessions in Informatica
Differentiate between mapping parameter and mapping variable?
What are session parameters ? How do you set them?
How many ways you create ports?