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 / balaganesh
SQ-->SRT-->EXP-->AGG-->TGT
In SRT:
sort the record by col1 (Ascending)
In Exp:
col1
col2
v_col2=iif(v_col1=col1,v_col2||','||col2,col2)
v_maxcount=iif(v_col1=col1,v_maxcount+1,1)
v_col1=col1
o_col1=v_col1
o_col2=v_col2
o_maxcount=v_maxcount
In AGG:
Group by o_col1
MAX(o_maxcount)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is rank transformation?
Explain the features of connected and unconnected lookup.
What is event and what are the tasks related to it?
What is a dimensional model?
list out all the transformations which use cache?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What are the tuning techniques you applied during your last project
generate date / time dimension in informatica
What is the use of target designer?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Why do we need informatica?
What is the advantage of informatica?
What are the new features of informatica 9.x in developer level?
my source is junk data how will u remove that junk data by using unix please any one replay me
How many numbers of sessions can one group in batches?