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
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Informatica Checkpoints
How many input parameters can exist in an unconnected lookup?
What is the fact table?
What are the mapping parameters and mapping variables?
What are the differences between joiner transformation and source qualifier transformation?
What do you mean incremental aggregation?
What are the guidelines to be followed while using union transformation?
How many number of sessions can one group in batches?
What is union transformation in informatica?
How can a transformation be made reusable?
Performance tuning( what you did in performance tuning)
What does role playing dimension mean?
What are the different components of powercenter?
How to extract the informatica rejected data?