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
Where is metadata stored?
What is Index Caches size?
What does cheating measurement mean?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How can repository reports be accessed without sql or other transformations?
What are the transformations that are not supported in mapplet?
What is the status code in stored procedure transformation?
What is the need of an ETL tool?
Enlist the advantages of informatica.
What is the commit type if you have a transaction control transformation in the mapping?
What is the session task and command task?
Can we get 1st record through Informatica(without sequence number).
As union transformation gives UNION ALL output, how you will get the UNION output?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Explain direct and indirect flat file loading (source file type) - informatica