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
- 11227 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
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
can u any challenge your project?
What is the use of an aggregator cache file?
What are the new features of informatica 9.x developer?
What is a router transformation?
What are connected or unconnected transformations?
How can we delete duplicate rows from flat files?
design of staging area?
How many ways are there to create ports?
What are roles and groups and benefits of using them?
What does “tail –f” command do and what is its use as an Informatica admin.
What is powercenter on grid?
What is Cognos script editor?
What are active and passive transformations?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
where to store informatica rejected data?
