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
Answer Posted / dev
Thanks a lot to both babu and moorthy for ur valuable time
for my doubt but i have another doubt is that as we are
assigning the port sal to prev_sal port how it holds the
previous sal as becz the currently it is holding the current
sal...... can u just explain me ...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are some examples of informatica etl programs?
scenario where i can use only concurrent execution of workflow.
How to load last n records of file into target table - informatica
What could be the possible resons of locks by user?
What is target designer and target load order?
How to partition the Session?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Which are the different editions of informatica powercenter that are available?
How we can create indexes after completing the load process?
What is flashback table ? Advance thanks
What is the Process to creating lookup transformation in informatica
What differs when we choose the sorted input for aggregator transformation?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What are mapplets?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance