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

Categories >> Software >> Data Warehouse >> Data Stage
Suggest New Category

Question Posted / vkrish

13 Answers
20776 Views
Polaris, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / poornachandrababu.l

Hi, This is Poorna,
take a source and then copy stage,to copy stage 2 o/p links
one output is for aggregator and other for join.

In aggregator
set group=deptno
aggregator type=calculation
column for calculation=sal
max value output column=sal.

In Join stage do equee join based on deptno and sal .

And pass output of join Stage to target.
By doing this wasy we can get Max(sal) of the employee on
particular department.

Is This Answer Correct ?

12 Yes

0 No

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

Answer / 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

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

Answer / 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

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

Answer / subbuchamala

SRC--> COPY stage--> 2 o/p links from COPY Stage-->
one is --> AGGREGATOR and other is --> JOIN-->TGT

-->In AGG Stage:
set group=DEPNO
aggregator type=calculation
column for calculation=SAL
max value output column=SAL

-->O/P of AGG Stage:
SAL(max(sal), DEPNO

-->In JOIN stage:
Inner Join on DEPNO and SAL and get the EMPNO as well.
By doing this, we get Max(sal) of the employee on particular DEPNO.

Is This Answer Correct ?

2 Yes

0 No

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

Answer / guest

we can retrive the max(sal),deptno,empno in aggreator stage.
way is
set group=deptno
aggregator type=calculation
column for calculation=sal
max value output column=max(sal)

Is This Answer Correct ?

6 Yes

5 No

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

Answer / vamsi

hi,
u r absalutely write
but here the question is to retrive the empno also.....

Is This Answer Correct ?

0 Yes

0 No

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

Answer / srikanth

hi vamsi
this is srikanth
if it is seq file
it is not at all possible
because we need to get the empno,deptno also.

Is This Answer Correct ?

0 Yes

0 No

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

Answer / srinu

select sal,deptno,empno from emp where sal=(select max(sal)
from emp);
this is write answer check that......after checking any
queries ask me..........

Is This Answer Correct ?

1 Yes

1 No

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

Answer / vamsi

when the data is in seq file , how we can get?

Is This Answer Correct ?

0 Yes

0 No

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

Answer / srikanth

hi srinu this is srikanth
very good
but
give the perfect clarity to the users along with the navigations
any way good solutions

Is This Answer Correct ?

0 Yes

0 No

Post New Answer