Partition and sort
Posted: Thu Mar 29, 2012 9:30 am
Hello,
We have a requirement where we need to sort on 10 keys, then remove duplicates based on the first 8 keys out of the 10 keys and then join based on the first 9 keys out of the 10 keys. We have two sorter stages and then a join stage but the partition method chosen seems to not give us the right output. I am looking for the partition and sorting approach that can be used in the above stages. We tried different options of partition but still confused.
Thanks.
We have a requirement where we need to sort on 10 keys, then remove duplicates based on the first 8 keys out of the 10 keys and then join based on the first 9 keys out of the 10 keys. We have two sorter stages and then a join stage but the partition method chosen seems to not give us the right output. I am looking for the partition and sorting approach that can be used in the above stages. We tried different options of partition but still confused.
Thanks.