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



SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL ..

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

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL ..

Answer / davankumar

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

Is This Answer Correct ?    1 Yes 0 No

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL ..

Answer / gangadhar799

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

Is This Answer Correct ?    0 Yes 0 No




SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL ..

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

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL ..

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

how to run 2 workflows sequentially. plz respond what is the process?

9 Answers   Target, Cap Gemini,


Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation

1 Answers   Puma,


my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,


what is surrogate id ?

3 Answers   IBM,


What is souce qualifier transformation it is active or passive

2 Answers   HCL,






What are the data movement modes in informatcia?

3 Answers  


can you avoid static cache in the lookup transformation? I mean can you

1 Answers  


WAT IS TEXT LOAD?

3 Answers   Wipro,


Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  


How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   TCS, iFlex,


my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,


How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 Answers  






Categories