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

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

Is it possible to revert a global repository to local one and why?

0 Answers  

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  

In development project what is the process to follow for an etl developer from day1

0 Answers  

What are the challenges of Dataware housing in the future?

2 Answers   HP,

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,

What is the format of informatica objects in a repository?

0 Answers  

What is informatica powercenter repository?

0 Answers  

How can you join two tables without any common column present in them?

1 Answers   TCS,

while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,

Do you find any difficulty while working with flat files as source and target?

0 Answers  

In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

2 Answers   Wipro,