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 / rambhupal
by using variable port also we can solve this.create one variable port and output port,assign that v_count=v_count+salary,for out port o_count=v_count
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is substr in informatica?
What are the components of workflow manager?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
write a query to retrieve the latest records from the table sorted by version(scd)
Explain the types of lookup transformation?
What is fact table? Explain the different kinds of facts.
what are the deliverables?in your project?
How to implement security measures using repository manager?
What are the transformations that are not supported in mapplet?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
COM components can be used in Informatica
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is DR strategy for Informatica project?
what is degenerated dimension?