My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000).
In the Target I want the following EmpID, Salary,
Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103,
3000, 6000). Please guide on how to build the mapping.
Answer Posted / priyank
Var_SAL=IIF(Var_SAL=0,SAL,Var_SAL+SAL)
Out_SAL=Var_SAL
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is DR strategy for Informatica project?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What are the tasks that can be performed using sq?
What is pmcmd command?
How does a sorter cache works?
What is the need of etl tools?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are the mapping parameters and mapping variables?
How to call shell scripts from informatica?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are active transformations.
How you know when to use a static cache and dynamic cache in lookup transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are different types of transformations available in informatica?
Differentiate between a repository server and a powerhouse?