Data stage Scenarios Interview Based Question No 8

I want the sum of the Each department number salary with out using Aggregator
Source File: Target
DEPT NO,        SAL Count
10, 1000             1000
10, 1100              2100
10, 1200             3300
20, 1100             1100
20, 1200            2300
30, 1200            1200
30, 1300            2500
30, 1400            3900

 

Related Posts Plugin for WordPress, Blogger...

Be the first to comment

Leave a Reply

Your email address will not be published.


*