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)
508Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
337
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How do u convert the columns to rows in datastage?
What are datastage sequences?
What are the different types of lookups in datastage?
Differentiate between validated and Compiled in the Datastage?
What is the use of datastage director?
Differentiate between odbc and drs stage?
Difference between server jobs & parallel jobs?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How to Remove Duplicate using SQL?
What is the difference between passive stage and active stage?
What is the difference between datastage and informatica?
What are the differences between datastage and informatica?
Explain how a source file is populated?
