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 / suresh
we have a predefined function in informatica CUME()
in expression t/r. donot struggle for writing logics
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Define filter transformation?
What are the databases that informatica can connect to windows?
Explain load alternative records / rows into multiple targets - informatica
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
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
Describe the impact of several join conditions and join order in a joiner transformation?
lookup transformation with screenshots
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Explain lookup transformation in informatica
How to use procedural logic inside infromatica?
Can informatica load heterogeneous targets from heterogeneous sources?
In how many ways we can create ports?
What is dimensional table? Explain the different dimensions.
How to start a workflow using pmcmd command?