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 / 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 is the fact table?
What are the differences between source qualifier and joiner transformation?
What does refresh system mean, and what are its distinctive choice?
Design time, run time. If you don't create parameter what will happen
How do you promote a non-reusable transformation to reusable transformation?
What are different types of transformations available in informatica?
What is native users?
what is index?how it can work in informatica
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the Process to creating lookup transformation in informatica
How to load a Dimension ? and how to load a fact table?
Differences between connected and unconnected lookup?
Scheduling properties,whats the default (sequential)
What is a transaction control transformation?
What is the difference between a repository server and a powerhouse?