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 is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2537


What is staging variable?

618


What are the functionalities of link partitioner?

612


On which Dimension Table you implemented SCD Type in your Project

1571


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

2837






How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1693


What are iconv and oconv?

767


What is "fatal error/rdbms code 3996" error?

660


What are the enhancements made in datastage 7.5 compare with 7.0?

705


What is the use of hoursfromtime() function in transformer stage in datastage?

580


Explain entity, attribute and relationship in datastage?

629


Define oconv () and iconv () functions in datastage?

871


What is the command line function to import and export the ds jobs?

675


what is the use of skid in reporting?

1949


Define repository tables in datastage?

697