SOURCE
NAME SAL
GANGA 30000
RAJU 20000
PAVAN 25000
TARGET
NAME SAL MAXSAL
GANGA 30000 30000
RAJU 20000 30000
PAVAN 25000 30000
in mapping level how to achive that
Answer Posted / abhinav
step1:Pass on the source(name,sal) to an expression
transformation.
create a dummy port and give the value as 1.
In the expression transformation, the ports will be
Name
sal
O_dummy=1
Step2:Pass only the salary port from source to aggregator
transformation.
create a dummy port with the same data type as in expression
and give the value as 1
create an output port with Max(Salary)
In the aggregator transformation, the ports will be
sal
O_dummy
O_sum_salary=max(salary)
Step3:Send the output from the 2 transformation to a joiner
transformation.
Ensure you have checked the sorted input option.
Join both the transformation on the Dummy port.
Step4:Send the output to the target.
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is domain and gateway node?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are the issues you have faced in your project? How did you overcome those issues?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is expression transformation?
What are the reusable transformations?
What is joiner change?
Explain the types of lookup transformation?
How to do unit testing in informatica?
whats the logic to load the lower level of granularity of data to fact table.
What do you understand by SOA of Informatica?
Explain the shared cache and re-cache?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is a passive transformation?