1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / prasad

Answer Posted / prasad

select empno,sal,deptno from tablename where (sal,deptno)in(select max(sal),deptno from tablename group by deptno)



in datastage

oracle stage->aggregator stage->lookup->dataset

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between datastage and datastage tx?

683

Explain datastage architecture?

928

What are the steps needed to create a simple basic datastage job?

770

What are the components of datastage?

745

Define APT_CONFIG in Datastage?

747




how to sort two columns in single job in datastage.

2640

table actions available in oracle connector?

1202

what is the use of materialized view?

1052

Could anyone give brief explanation bout datastage admin

2052

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1066

options available in sequence job to run,validate?

942

What are the different types of lookups in datastage?

708

Define Job control?

759

How many areas for files does datastage have?

723

What is the use of datastage designer?

723