Data stage Scenarios Interview Based Question No 9

I want the count sum of the salary on Each department wise
Source File:                                 Target
DEPTNO, SAL               Deptno,             Sum_Sal
10, 1000                            10,                     3300
10, 1100                             20,                     2300
10, 1200                            30,                      3900
20, 1100
20, 1200
30, 1200
30, 1300
30, 1400

Related Posts Plugin for WordPress, Blogger...

Be the first to comment

Leave a Reply

Your email address will not be published.


*