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
- 10714 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
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Explain the code page compatibility?
what is unit testing?tell me proceedure
Is it possible to define a single node as a Gateway node as well as worker node?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How can you define user defied event?
differences between service based and product based?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What are the guidelines to be followed while using union transformation?
Plz can any one say me how to get the informatica certification materials and dumps
what is mean by complex business rule ?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Informatica Checkpoints
can anyone explain me about retail domain project in informatica?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
