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

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

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

Differentiate between reusable transformation and mapplet.

1144


What is standalone command task?

1376


Can we create two repositories on same database instance in oracle?

1145


Define joiner transformation?

1107


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

2096


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

1193


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1180


Explain pushdown optimization $pushdownconfig parameter - informatica

1195


What is domain in terms of informatica?

1059


How big was your fact table

1864


What is a filter transformation and why it is an active one?

1016


What is mapplet in informatica?

1129


wat are deployement groups in informatica, how it will be used for developers

1776


How can we use batches?

1066


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1123