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

in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,

Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

10 Answers   CSC,

What are mapping parametres and variables in informatica?

6 Answers   TCS,

What is difference between Mapplet and reusable transformation?

9 Answers   Wipro,

what is the mechanism of the Master-Detail joining condition?

6 Answers   IBM, Patni,

What is workflow manager?

0 Answers  

how can u load the data in time dimension?

3 Answers  

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 Answers  

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

What is dimensional table?

0 Answers  

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,

What is aggregate cache in aggregator transformation?

0 Answers   Informatica,