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 a transaction control transformation?
how we can load rejected record's at run time?(not through bad files)
How might you approve all mappings in the archive all the while?
How to start a workflow using pmcmd command?
what are the deliverables?in your project?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
can we override a native sql query within informatica? Where do we do it? How do we do it?
explain abt ur project architecture?
What is a dimensional model?
Write the unconnected lookup syntax and how to return more than one column.
What is enterprise data warehousing?
Can you generate sequence numbers without using the sequence generator transformation?
What is a router transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is native users?