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

root tree will find which is server job and which is parallel job?

1457


I have a few records just I want to store data in to targets cycling way how?

1902


Can you explain engine tier in information server?

653


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

365


Define meta stage?

786






Explain Quality stage?

671


Can you explain tagbatch restructure operator?

705


Where the datastage stored his repository?

618


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

1633


What could be a data source system?

581


Which algorithm you used for your hashfile?

692


What are the functionalities of link partitioner and link collector?

600


What are the components of datastage?

658


Explain connectivity between datastage with datasources?

600


What are sequencers?

616