how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql.
output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
No Answer is Posted For this Question
Be the First to Post Answer
How do you design PX Routines ?
Difference between JOIN,LOOKUP,MERGE?
how to retrive the max(sal),deptno,empno in datastage?
In Datastage, how you can fix the truncated data error?
how to cleansing data
Is there any possibility to generate alphanumeric surrogate key?
Can aggregator and transformer stages use to sort the data? How ?
in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?
What is the difference between operational data stage (ods) and data warehouse?
by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?
What is the use of surrogate key stage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join