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 expression transformation?
What are junk dimensions?
What is informatica metadata and where is it stored?
Target increases every day even though no new record was inserted
How is union transformation utilized?
Explain the types of transformations?
Which files are created during the session rums by informatics server?
What are the reusable transformations?
What is resilience time?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is a difference between complete, stop and abort?
How you can differentiate between connected lookup and unconnected lookup?
What is the commit type if you have a transaction control transformation in the mapping?
How you know when to use a static cache and dynamic cache in lookup transformation?
Define Pmrep command?