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 |
Explain one complecated mapping?
What is the difference between lookup override and souce qualifier override ?
how to join the two flatfiles using the joiner t/r if there is no matching port?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
What are the different types of Type2 dimension maping?
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
What is the difference between Active and Passive transformation?
How to prepared lld.can any one tell me detailed explanetion.
Why we select the table which has minimum number of records as Master table in joiner?
What are limitations of joiner transformation?
What are the prerequisite tasks to achieve the session partition?