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
in oracle target stage when we use load option and when we use upsert option?
Define project in datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
what are the different type of errors in datastage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is process model?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com
what is a force compile
Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,
What is diff between Junk dimensions and conform dimension?
HOW CAN WE SEE THE DATA IN DATASET?