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
- 911 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
how to implement scd2 in datastage 7.5 with lookup stage
What are the types of views in datastage director?
What are datastage sequences?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..
how to closeing records after 10,000 records come?
what is meta data? Explain? Where it is used?
How and where you used hash file?
How many nodes supported by a one cpu in parallel jobs?
How we can convert rows to columns in datastage?
what is advantages of snowflake when it is used?
1.what is materialized data? 2.how to view the materialized data?
Teradata 
