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.

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

Answer / santhosh

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

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.

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)

Answer / vamsi

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

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.

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..........

Answer / vamsi

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

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

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   IBM,

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

1 Answers   TCS,

How to Convert a string function to date function by using only sequential file stage with out using other stages ?

5 Answers   TCS,

DataStage Scenario based Interview Questions

1 Answers  

Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

2 Answers   TCS,

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

0 Answers   IBM,

What all the types of jobs you developed?

0 Answers  

Distinguish between informatica & datastage. Which one would you choose and why?

0 Answers  

how to sort two columns in single job in datastage.

1 Answers   TCS,

Explain the ChangeApply stage?

11 Answers  

What is aggtorec restructure operator?

0 Answers  

What are constraints and derivations?

0 Answers