Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 10803 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
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
How can informatica be used for an organization?
What are pre and post-session shell commands?
What is meant by LDAP users?
Mention few advantages of router transformation over filter transformation.
What does command task mean?
What is workflow monitor?
What are the types of caches in lookup? Explain them.
Can we override a native sql query within informatica?
What are the prerequisite tasks to achieve the session partition?
Slowly changing dimensions, types and where will you use them
How to start a workflow using pmcmd command?
Is it possible to define a single node as a Gateway node as well as worker node?
What is workflow? What are the components of the workflow manager?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Differences between version 7.x and 8.x.
