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
Explain informatica architecture - version 8 / 9
To import the flat file definition into the designer where should the flat file be placed?
What is target designer and target load order?
What are the different lookup cache(s)?
Scheduling properties,whats the default (sequential)
Explain lookup transformation in informatica
Explain what are the different versions of informatica?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is dimensional table?
What is meant by LDAP users?
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
Target increases every day even though no new record was inserted
Write the different tools in the workflow manager?
What is informatica powercenter repository?
How to generate sequence numbers using expression transformation?