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
what are the errors,warnings in datastage
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...
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...
whom do you report?
What are the difference types of stages?
Define Data Stage?
What are stage variables?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
how do u catch bad rows from OCI stage? And what CLI stands for?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are the different kinds of views available in a datastage director?
How many Key we can define in remove duplicate stage?
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
How one source columns or rows to be loaded in to two different tables?