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 are the errors,warnings in datastage

2386


How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1272


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

3947


whom do you report?

1713


What are the difference types of stages?

811


Define Data Stage?

844


What are stage variables?

873


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2262


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

3031


how do u catch bad rows from OCI stage? And what CLI stands for?

2528


Different ways a project can be moved to production ?...example ….export-import and Version control.

2176


What are the different kinds of views available in a datastage director?

791


How many Key we can define in remove duplicate stage?

1032


1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

1878


How one source columns or rows to be loaded in to two different tables?

887