Answer / james

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

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

Answer / simha

The above answer is absolutely correct

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.

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

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

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

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,

In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1 Answers   HP,

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers  

What is the need for an etl tool?

0 Answers  

Describe the impact of several join conditions and join order in a joiner transformation?

0 Answers  

What is the use of transformation?

0 Answers  

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,

comonly how meny mappings r there in Banking projects?

1 Answers  

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,