how to get minimum value without using aggregator stage
Moderators: chulett, rschirm, roy
how to get minimum value without using aggregator stage
I hve the data like this
Deptno sal
-------- -------
10 3000
10 234000
10 3434
20 3547
30 4544
40 4656
40 3434
20 5767
I neet to get deptno with minimum sal ..... but without using aggregator!
Thanks in advance.
Deptno sal
-------- -------
10 3000
10 234000
10 3434
20 3547
30 4544
40 4656
40 3434
20 5767
I neet to get deptno with minimum sal ..... but without using aggregator!
Thanks in advance.
this is nice
-
- Participant
- Posts: 11
- Joined: Fri May 29, 2009 9:54 pm
- Location: hyd
Re: how to get min sal without using aggregator stage
friest filer basend on depno, then sort ase order on sal then the both depno and sal and using copy pass only one
-
- Participant
- Posts: 48
- Joined: Fri Feb 29, 2008 1:09 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: how to get min sal without using aggregator stage
Please replace your keyboard with one that can spell!sureshbabu wrote:friest filer basend on depno, then sort ase order on sal then the both depno and sal and using copy pass only one
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
Re: how to get min sal without using aggregator stage
skyboyfli wrote:I hve the data like this
Deptno sal
-------- -------
10 3000
10 234000
10 3434
20 3547
30 4544
40 4656
40 3434
20 5767
I neet to get deptno wise min sal ..... but without using aggregator!
Thanks in advance.
Job interview?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
im having 6 nodes system..swathi Singamareddygari wrote:Hi,
1)First sort the data based on Deptno and Sal in ascending order by using sort stage
2)After that use the remove duplicate stage and set Duplicates to retain to First
so sorting of two columns not giving expected results...
how to do this in multinode system
this is nice
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
... using a key-based partitioning algorithm, for example Modulus or Hash.ArndW wrote:If you get incorrect values with multiple nodes then you have partitioned incorrectly. You need to partition on DEPTNO.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
done
i made the sort stage in sequential mode....swathi Singamareddygari wrote:Hi,
1)First sort the data based on Deptno and Sal in ascending order by using sort stage
2)After that use the remove duplicate stage and set Duplicates to retain to First
and i got expected data
Thanks
this is nice