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 are the types of data warehouses?
What are the differences between a connected lookup and unconnected lookup?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
explain abt ur project architecture?
What does cheating measurement mean?
what is diff b/t sorter t/r and agg have the option sorter property...
How are indexes created after completing the load process?
How to elaborate tracing level?
How might one distinguish in the case of mapping is right or not without associating session?
Design time, run time. If you don't create parameter what will happen
How an expression transformation differs from aggregator transformation?
What is update strategy transform?
What are the mapping parameters and mapping variables?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is lookup change?