Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe data concatenation?

1088


What do you mean by blocking transformation?

1052


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1105


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3872


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

1130


Have you worked with/created Parameter file

1668


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2038


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1129


What is native users?

1174


What is the difference between a connected look up and unconnected lookup?

971


What does update strategy mean, and what are the different option of it?

1095


What is InformaticaPowerCenter?

1139


What is the difference between Active and Passive transformation?

1157


Where do we use mapping variables in informatica?

1074


How we can create indexes after completing the load process?

1163