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...

how can find maximum salary by using Remove duplicate stage?

Answer Posted / akila

In case an explicit sort stage is used like inteh reply
above, the sort will be done on emp_id(key field) and the
salary. But remove duplicate will be done only on emp_id. I
guess that this might result in a warning like 'sort and
remove duplicates keys do not match'.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of jobs we have in datastage?

1071


Describe link sort?

1009


how to run a sequential file stage in parallel if the stage is used on the TARGET side

1742


Terminate Activity

1272


What is meta stage?

1174


How to reverse the string using unix?

3502


What are the different type of jobs in datastage?

1041


in oracle target stage when we use load option and when we use upsert option?

2276


Which warehouse using in your datawarehouse

2182


How to read multiple files using a single datastage job if files have the same metadata?

1244


What is the purpose of interprocessor stage in server jobs?

2228


Can you highlight the main features of ibm infosphere information server?

1088


How do you import and export data into datastage?

1228


EXPLAIN SCD

1389


Can we use target hash file as a lookup ?

3323