Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 5 Answers
- 11068 Views
- Amdocs, I also Faced
- E-Mail Answers
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 the Rank index port in Rank transformation?
What is Index Caches size?
What are the issues you have faced in your project? How did you overcome those issues?
I have a flat file, want to reverse the contents of the flat file
Can we get 1st record through Informatica(without sequence number).
How to elaborate powercenter integration service?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
In which transformation you cannot drag ports into it?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What are the conditions needed to improve the performance of informatica aggregator transformation?
what is the difference between informatica6.1 and infomatica7.1
What is a joiner transformation?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
