how to retrive the max(sal),deptno,empno in datastage?

Answer Posted / santhosh

Take aggrigrator o/p as reference link to look up then you
will gwt require o/p

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 the sortmerge collector?

655


What are the types of containers in datastage?

696


what is the use of materialized view?

952


Can we use target hash file as a lookup ?

2806


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

354






How many types of views are there in a datastage director?

825


What is the difference between odbc and drs stage?

631


What are routines in datastage?

764


What is the process of killing a job in datastage?

579


How do you generate sequence number in datastage?

617


Can you explain repository tables in datastage?

892


What can we do with datastage director?

663


What is usage analysis in datastage?

803


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

1799


What are the types of hashed files in data stage

635