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




Answers were Sorted based on User's Feedback



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.

Is This Answer Correct ?    9 Yes 0 No

Answer / davankumar

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

Is This Answer Correct ?    1 Yes 0 No

Answer / gangadhar799

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

Is This Answer Correct ?    0 Yes 0 No




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.

Is This Answer Correct ?    0 Yes 0 No

Answer / pjr

SQ-->Agg-->TGT

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

Is This Answer Correct ?    0 Yes 4 No

Post New Answer



More Informatica Interview Questions

what is mystery dimension?

1 Answers  


what is update strategy transformation ?

7 Answers   TCS,


Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

1 Answers   Accenture, Patni,


suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,


what is threshold error in informatica?

1 Answers   TCS, Wipro,






i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,


What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers  


how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,


Can we change Dynamic to Static or Persistent cache? If so what happens?

0 Answers   TCS,


If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

1 Answers   Wipro,


What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 Answers  


If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers  






Categories