Data stage Scenarios Interview Based Question No 7

I want the count of the Each department number with out using Aggregate
Source File:             Target
DEPT NO,            SAL Count
10, 1000                     1
10, 1100                      2
10, 1200                     3
20, 1100                     1
20, 1200                    2
30, 1200                    1
30, 1300                    2
30, 1400                    3

 

Related Posts Plugin for WordPress, Blogger...

Be the first to comment

Leave a Reply

Your email address will not be published.


*