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


Please Help Members By Posting Answers For Below Questions

Explain informatica architecture - version 8 / 9

669


To import the flat file definition into the designer where should the flat file be placed?

677


What is target designer and target load order?

655


What are the different lookup cache(s)?

620


Scheduling properties,whats the default (sequential)

1468






Explain lookup transformation in informatica

648


Explain what are the different versions of informatica?

655


complex mapping ur project u r invlve can u explain and give real time example give me ?

1840


What is dimensional table?

621


What is meant by LDAP users?

695


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2066


Target increases every day even though no new record was inserted

1107


Write the different tools in the workflow manager?

575


What is informatica powercenter repository?

712


How to generate sequence numbers using expression transformation?

641