Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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

Post New Answer

More Data Stage Interview Questions

How do you design PX Routines ?

1 Answers  

Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,

how to retrive the max(sal),deptno,empno in datastage?

13 Answers   Polaris,

In Datastage, how you can fix the truncated data error?

0 Answers  

how to cleansing data

6 Answers   Cap Gemini,

Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,

Can aggregator and transformer stages use to sort the data? How ?

2 Answers  

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?

2 Answers   Wipro,

What is the difference between operational data stage (ods) and data warehouse?

0 Answers  

by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?

1 Answers  

What is the use of surrogate key stage?

2 Answers  

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

0 Answers