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 get log info into a file?
How to reverse the string using SQL?
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
in aggregator , how can i get the sum in readable format
what about data stage requirement
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
How do u view log file for a particular job?
Hi This is Vijay How Can u Read the data from sequential file Parall'y?
what are fact tables and dimension tables? give example assuming one table.
What are operators in datastage?
How do you start developing a datastage project?
Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)