Interested to Buy Any Domain ? << Click Here >> for more details...
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000
4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement
is like this id name sal up_sal,1 aa 1000 null,2 bb 2000
1000, 3 cc 3000 2000
4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on
so how can i get it plez reply for this as soon as possible
, thanks in advanced
- 9 Answers
- 11871 Views
- I also Faced
- E-Mail Answers
Answer Posted / moorthy, g
Hi
In the variable port you have add
pre_sal = v_SAL
v_sal=SAL
SAL = SAL
o_update_sal = pre_SAL
Best Regards,
Moorthy. G
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What does refresh system mean, and what are its distinctive choice?
How we can create indexes after completing the load process?
During the running session, output files are created by informatica server. Enlist few of them.
lookup transformation with screenshots
Explain direct and indirect flat file loading (source file type) - informatica
Explain the shared cache and re-cache?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is the cumulative sum and moving sum?
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.
Quickly characterize reusable change?
How identifying bottlenecks in various components of informatica and resolving them?
What is workflow manager?
As union transformation gives UNION ALL output, how you will get the UNION output?
How can we store previous session logs?
Explain about cumulative Sum or moving sum?
