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 migrate data from one environment to another?
What is sq transformation?
How do you load unique records into one target table and duplicate records into a different target table?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is data caches/ index caches?
Explain target update override in informatica
Explain in detail about scd type 1 through mapping.
Make a note of the quantity vaults made in informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the different ways to implement parallel processing in informatica?
permutations of mapplet
Differentiate between reusable transformation and mapplet.
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What are the mapping parameters and mapping variables?
Is stop and abort are same in informatica?