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)
- 0 Answers
- 512 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is a delta record? How you will read it?
Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5
if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
What are the different common services in datastage?
what is Audit table?Have u use audit table in ur project?
1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
options available in sequence job to run,validate?
How can we improve the performance in datastage?
what is flow of project?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
how many types of sorting the data in data stage?
Teradata 
