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 data merging,data cleansing,sampling?
Can i create a lookup table without cache.
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
explain about lookup t/r?
What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?
What is the difference between router and filter?
What is data transformation manager process?
What is the meaning of decode in informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
how to get max value record into one target and remaining records into another target?
What are the diffrences between joiner transformation and source qualifier transformation?
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time