select name,sal,(select max(sal) from t1) from t1

SOURCE

NAME SAL
GANGA 30000
RAJU 20000
PAVAN 25000

TARGET
NAME SAL MAXSAL
GANGA 30000 30000
RAJU 20000 30000
PAVAN 25000 30000

in mapping level how to achive that

Question Posted / davankumar

5 Answers
10992 Views
DELL, I also Faced
E-Mail Answers

Answer Posted / davankumar

select name,sal,(select max(sal) from t1) from t1

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Reusable transformation and shortcut differences

1822

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1127

Explain about Informatica server process that how it works relates to mapping variables?

1047

What is informatica etl tool?

987

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2228

Name the different lookup cache(s)?

1214

Enlist the advantages of informatica.

1047

What is complex mapping?

1106

How can we update a record in the target table without using update strategy?

1123

what is Active lock explain

2772

Explain the etl program with few examples.

1031

In warehouses how many schemas are there?

1058

Explain the aggregator transformation?

1134

wf dont have integration severances how you can run?

1925

What are the differences between a connected lookup and unconnected lookup?

1057