1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / gangadhar799

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

what type of transformation is not supported by mapplets?

4 Answers   CTS,

What are the types of lookup transformation?

0 Answers   Informatica,

What is the use of incremental aggregation?

2 Answers  

Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,

Define mapplet?

0 Answers  




Explain about Informatica server process that how it works relates to mapping variables?

0 Answers   Informatica,

WAT IS TEXT LOAD?

3 Answers   Wipro,

Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

4 Answers   IBM,

Enlist the advantages of informatica.

0 Answers  

Describe expression transformation?

0 Answers  

How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers   Wipro,

For more Informatica Interview Questions Click Here
Categories