how to retrive the max(sal),deptno,empno in datastage?
Answer Posted / 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 |
Post New Answer View All Answers
how to export or import the jobs in .ISX file
How do you start developing a datastage project?
Whats difference betweeen operational data stage (ods) and data warehouse?
What are the types of views in datastage director?
If you want to use the same piece of code in different jobs, how will you achieve it?
What is datastage engine?
Notification Activity
How many types of views are there in a datastage director?
What is the different type of jobs in datastage?
Which algorithm you used for your hashfile?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What are some prerequisites for datastage?
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 to find value from a column in a dataset?
What are stage variables, derivations and constants?