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
Explain connectivity between datastage with datasources?
How you Implemented SCD Type 1 & Type 2 in your project?
What is the difference between operational data stage (ods) and data warehouse?
In Datastage, how you can fix the truncated data error?
What is the command line function to import and export the ds jobs?
Explain Quality stage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What are the types of containers and how to create them?
How complex jobs are implemented in datstage to improve performance?
On which Dimension Table you implemented SCD Type in your Project
What are the different options associated with dsjob command?
Demonstrate experience in maintaining quality process standards?
How many types of sorting methods are available in datastage?
Describe stream connector?
Describe the architecture of datastage?