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

How many types of sessions are there in informatica.please explain them?

1211

How many ways a relational source definition can be updated and what are they?

1068

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

1760

Explain the difference between a data warehouse and a data mart?

1112

How can we create index after completion of load process?

1166

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

1242

what are 3 tech challenges/ common issues you face?

2397

Explain sessions and how many types of sessions are there?

1060

Implementation methodology

1773

What are the restrictions of union transformation?

1088

Partition, what happens if the specified key range is shorter and longer

2557

What is the need of an ETL tool?

1160

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2189

How can we delete duplicate rows from flat files?

1311

What are the different types of transformation available in informatica.

1147