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

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

Question Posted / james

Answer Posted / james

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

Is This Answer Correct ?

13 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between a repository server and a powerhouse?

816

What are the different options available for update strategy?

580

Name the different lookup cache(s)?

711

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1338

How to handle decimal places while importing a flatfile into informatica?

727

What is pmcmd command?

677

What is repository manager?

538

can any one give some examples for pre sql and post sql(Except dropping and creating index).

3511

How to generate sequence numbers using expression transformation?

645

What is a standalone command task?

656

Is it possible to use a client with different version than that of its Informatica server?

645

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

4987

Explain the scenario which compels informatica server to reject files?

658

What is option by which we can run all the sessions in a batch simultaneously?

667

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1585