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 / 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 workflow manager?
How to create a non-reusable instance of reusable transformations?
What are junk dimensions?
How to open an older version of an object in the workspace?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the main features of Oracle 8i with context to datawarehouse?
What is dimensional table?
What are the reusable transformations?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is resilience time?
How to update source definition?
tell me the rules and responsblites in our project(my project is development)
What are the differences between joiner transformation and source qualifier transformation?
What is decode in informatica?