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 to get max salary of an organization using data stage
stages...........

can any body help me plz.......

Answer Posted / shar

ok lets us say after getting result like
a,8000
b,9000
c,9999
acc to nandhini using dummy key would give me
a,8000,1
b,9000,1
c,9999,1
then use rem duplicate stage then we get 9999 as output after we assign retain duplicates=last for dummykey col.
what if
i have diff data and got output like below after aggreagation
a,9000
b,18000
c,10000
now what...?

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name the command line functions to import and export the DS jobs?

1091


what is repositery?

1771


What all are the different way to run a job?

1030


What is the use of datastage designer?

1090


How do you schedule or monitoring the job?

1135


What are orabulk and bcp stages?

1069


What are the partitioning techniques available in link partitioner?

2228


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2196


If you want to use a same piece of code in different jobs, how will you achieve this?

1224


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2408


What are the different type of jobs in datastage?

1002


Why fact table is in normal form?

1150


why do u need the IOS upgradation in a FC switch

2225


What are the components of datastage?

1066


What is apt_config in datastage?

1084