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
EXL informatica Questions
Describe expression transformation?
How can you increase the performance in joiner transformation?
how to load rows into fact table in data warehouse
What is transformation?
explain about unit testing? in real time?
Mention some types of transformation?
What is an Integration service in Informatica?
Explain about cumulative Sum or moving sum?
How to load last n records of file into target table - informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the new features of Power Center 5.0?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Target increases every day even though no new record was inserted
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?