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


Please Help Members By Posting Answers For Below Questions

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

976


What is domain and gateway node?

668


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

576


What are the issues you have faced in your project? How did you overcome those issues?

1890


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 .

1442






What is expression transformation?

611


What are the reusable transformations?

676


What is joiner change?

651


Explain the types of lookup transformation?

539


How to do unit testing in informatica?

689


whats the logic to load the lower level of granularity of data to fact table.

1764


What do you understand by SOA of Informatica?

568


Explain the shared cache and re-cache?

592


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

572


What is a passive transformation?

617