Interested to Buy Any Domain ? << Click Here >> for more details...
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
- 5 Answers
- 11947 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / abhinaw prakash
You can make use of Variable ports for storing values
coming as input.For output you can compare values and give
the output.
the expression for output will look something like
IIF(Input_sal=v_prev_sal,v_prev_sal,input_sal+v_prev_sal)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
explan ur project architecture?
How do we call shell scripts from informatica?
how tokens will generate?
wat are deployement groups in informatica, how it will be used for developers
Explain the different lookup methods used in informatica?
can we override a native sql query within informatica? How do we do it?
What is a code page?
What is persistent lookup cache?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is substr in informatica?
differences between service based and product based?
Describe data concatenation?
How to improve the performance of a session using sorter transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How to create the source and target database connections in server manager?
