source target
--------- --------
name no sal name no sal max_sal
r 10 1000 r 10 1000 3000
y 20 3000 y 20 3000 3000

Answers were Sorted based on User's Feedback



source target --------- -------- name no sal ..

Answer / james

select name,no,sal,(select max(sal) from emp) as max_sal
from emp;

Is This Answer Correct ?    13 Yes 0 No

source target --------- -------- name no sal ..

Answer / venkatesh malneni

source-->sq-
| \-------------|
| --->aggr--->target
in target create a new column maxsal now drag the source and
target to the mapping area connect the source to sq.from sq
create two pipelines connect the first pipeline to the target
and the second pipeline to the aggr t/r in aggr t/r create a
new port max_sal=max(sal) connect this pipe line to the target

Is This Answer Correct ?    8 Yes 2 No

source target --------- -------- name no sal ..

Answer / simha

The above answer is absolutely correct

Is This Answer Correct ?    3 Yes 0 No

source target --------- -------- name no sal ..

Answer / abhinav prakash

1.Pass the ports to an expression t/r.
create a dummy port and give the value as '1'
2.Pass only the salary port to an Aggregator t/r.
Create a dummy port with the same data type and column name
and value as expression.
create o/p port:max(salary)
3.Join these 2 t/r using joiner and join on the dummy port.
ensure u have checked the sorted input option.
4Pass the o/p to the target.

Is This Answer Correct ?    2 Yes 0 No

source target --------- -------- name no sal ..

Answer / ravikishore

JAMES YOUR ANSWER IS CORRECTIN IN ORACLE,BUT I WANT ANSWER
IN INFORMATICA LEVEL AND UR SOURCE IS FLAT FILE HOW TO DO

Is This Answer Correct ?    1 Yes 0 No

source target --------- -------- name no sal ..

Answer / james

Hey Babu,

I've tried your query.
It's not working for me.
Please double check it.

And u said my query doesn't work.
It works absolutely fine for me.
Please let me know where my went wrong.

Waiting for your reply.
-James

Is This Answer Correct ?    0 Yes 0 No

source target --------- -------- name no sal ..

Answer / babu

HI James and Simha,
I think u r answer is wrong,please check once.

as per my knowledje,the query is
SELECT E.*,M.MSAL FROM TABLE_NAME E,(SELECT MAX(SAL) MSAL
FROM TABLE_NAME) M;

IF U R SOURCE IS FLATFILE,U NEED TO GO FOR BELOW MAPPING.

SQ----->TRG_TABLE
|
|---->AGG(MAX(SAL))--->TRG_TABLE(MSAL)
IN THE ABOVE DFD IS
1 SOURCE TO TARGET DIRECT MAPPING ALL COLUMNS EXCEPT
MSAL COLUMN.
2.IN THIS DFD FIND THE MAXSAL AND LINK TO IT MSAL IN
THE TARGET TABLE.

IF THERE IS ANY WRONG PLEASE CORRECT ME.

THANKS,
Babu

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Informatica Interview Questions

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

0 Answers  


Router T/R is active but some people are saying it is also passive which is exactly right?

5 Answers  


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

0 Answers  


What are the types of lookup transformation?

0 Answers   Informatica,


What is repository manager?

0 Answers  






What is rank transform?

0 Answers  


What is souce qualifier transformation it is active or passive

2 Answers   HCL,


What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,


i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,


Where are the source flat files kept before running the session?

0 Answers   Informatica,


How to do unit testing in informatica? How to load data in informatica ?

0 Answers  


What are the modules in Power Center

0 Answers  


Categories