Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 923 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?
What a datastage macro?
Explain entity, attribute and relationship in datastage?
what is factless fact table?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How can we do null handling in sequential files?
how to transfer file from one system to another system in unix? which cmd to be use?
How can we improve performance of data stage jobs?
I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????
What are the steps required to kill the job in Datastage?
Lookup constraints
Teradata 
