source : col1 101 101 101 102 102 102 103 103 103
col2 1000 1500 2000 1200 2300 3000 2400 1300 2000
i need target as
col1 101 102 103
col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
Answer Posted / s
INPUT
col1 col2
101 1000
101 1500
101 2000
102 1200
102 2300
102 3000
103 2400
103 1300
103 2000
OUTPUT
col1 col2
101 1000,1500,2000
102 1200,2300,3000
103 2400,1300,2000
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 ? | 11 Yes | 3 No |
Post New Answer View All Answers
What do you mean incremental aggregation?
What do think which one is the better joiner or look up?
Partition, what happens if the specified key range is shorter and longer
How do you migrate data from one environment to another?
How an expression transformation differs from aggregator transformation?
What are the types of lookup transformation?
What is the sql query overwrite in source qualifier in informatica
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Can you generate sequence numbers without using the sequence generator transformation?
How to do unit testing in informatica?
What is sequence generator transformation in informatica?
What is sorter transformation?
What are the tasks that source qualifier perform?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures