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
- 11075 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / siva
In expression add one column and make it output(sal1) and
salary port as input only.
We will make use of a function named cume(salary) to solve
our problem, rather using any complex mapping
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
what is the -ve test case in your project.
What is the difference between source qualifier transformations source filter to filter transformation?
What is the scenario which compels informatica server to reject files?
Which are the different editions of informatica powercenter that are available?
How many ways a relational source definition can be updated and what are they?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is informatica worklet?
What do you understand by term role-playing dimension?
tell me the rules and responsblites in our project(my project is development)
How would you copy the content of one repository to another repository?
What is lookup transformation?
Explain the different lookup methods used in informatica?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
