how to retrive the max(sal),deptno,empno in datastage?
Answer Posted / 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Give an idea of system variables.
what is the use of materialized view?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
How to perform incremental load in datastage?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
How you can fix the truncated data error in datastage?
how to sort two columns in single job in datastage.
Define ds designer?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How to reverse the string using unix?
which r the connectors used in san?
How to find value from a column in a dataset?
What is ibm datastage?
What is quality stage?
Can you explain players in datastage?