Answer / 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.

Answer / davankumar

select name,sal,(select max(sal) from t1) from t1

Answer / gangadhar799

orcle level you are 100% correct but in informatica level
how to configure mapping

Answer / shekar

After source qulifier add a expression transformation in
the expression transformation create out put port name it
as maxsal then derive the code for this out put port as
setmaxvariable(sal).
Then pass the output ports from expression to target table.

Answer / pjr

SQ-->Agg-->TGT

in aggrigator create on new out_port max_sal=max(sal) then
give connection to tgt MXASAL

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

State the limitations where we cannot use joiner in the mapping pipeline?

0 Answers  

What are events in workflow manager?

1 Answers   Accenture, IBM,

Briefly define reusable transformation?

0 Answers  

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

4 Answers   Cap Gemini, IBM,

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 Answers  

tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

3 Answers   IBM, Patni, TCS,

Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,

what is the location of parameter file in informatica?

1 Answers   TCS,

what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,

What are the tasks that can be performed using sq?

0 Answers  

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers