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 retrive the max(sal),deptno,empno in datastage?

Answer Posted / nagaraju k

first take oracle->aggregator->lookup->dataset
next take 2oracle stages and then take join stage join to connect lookup stage then success fully answre will come

Any doubt means call me
+960022516

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between server jobs & parallel jobs?

1081


How do you import and export the datastage jobs?

1161


Define Data Stage?

1097


What is datastage engine?

1183


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3347


Describe the architecture of datastage?

1010


What is a quality stage in datastage tool?

1079


What all the types of jobs you developed?

1181


What is the difference between hashfile and sequential file?

1263


What is orabulk stage?

1048


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

2244


Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2904


Which commands are used to import and export the datastage jobs?

1414


Define APT_CONFIG in Datastage?

1084


how to write server Routine coding?

2132