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

What are the types of containers?

1310


How can we improve the performance in datastage?

1146


What are the types of hashed files in data stage

1146


What are the functionalities of link partitioner and link collector?

1061


8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2263


Can we use target hash file as a lookup ?

3372


What are the functionalities of link collector?

1137


describe the Steps to confiure a Qlogic switch

2438


Can you explain tagbatch restructure operator?

1215


What are the different kinds of views available in a datastage director?

1075


What are the steps required to kill the job in Datastage?

1266


If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2100


What is ibm datastage?

1022


How to reverse the string using SQL?

1593


how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

857