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
- 10715 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / jayachandra
use expression transformation here take two variable ports
one varaible port as v_sal and one more variable port as
o_sal and assign as o_sal=o_sal+sal
and write condition csum as
iif(sal=v_sal,o_sal+sal,o_sal)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
During the running session, output files are created by informatica server. Enlist few of them.
What is event and what are the tasks related to it?
What is meant by incremental aggregation?
Is it possible to revert a global repository to local one and why?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are the tasks that source qualifier perform?
What is substr in informatica?
define galaxy repository in informatica
How is union transformation utilized?
How to improve the performance of a session using sorter transformation?
Why update strategy and union transformations are active?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
COM components can be used in Informatica
How many dimensions are there in informatica?
What is a repository manager?
