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 / ravi
Dear Babu,
Hope the execution sequence of the ports are as:
1. Input Port
2. Variable port.
3. Output.
Will u acknowledge for the above pl..??
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How do you change a non-reusable transformation to reusable transformation?
What is expression transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How to do the error handling of if ur source is flatfiles?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Explain the tuning lookup transformation - informatica
Explain sessions. Explain how batches are used to combine executions?
what are the Methods For Creating Reusable Transformations?
Explain the features of connected and unconnected lookup.
Explain direct and indirect flat file loading (source file type) - informatica
How to do unit testing in informatica? How to load data in informatica ?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the meaning of decode in informatica?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?