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 repository manager?
What is joiner transformation?
Explain sessions. Explain how batches are used to combine executions?
Separate from a database, an information bazaar, and an information stockroom?
Tell me about MD5 functions in informatica
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
In informatics server which files are created during the session rums?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What are multi-group transformations?
How would you copy the content of one repository to another repository?
What is the sql query overwrite in source qualifier in informatica
What is the reusable transformation?
How can we use mapping variables in informatica?
What is informatica?
COM components can be used in Informatica