Hi,
I'm getting following msg in a remove duplicate stage.
nkrmdup: When checking operator: User inserted sort "lnkrmdup.lnkrmdup_Sort" does not fulfill the sort requirements of the downstream operator "lnkrmdup"
I'm sorting the input records (using hash partition) on the same keys on which I'm removing duplicates. So why this msg is still coming? Can I avoid this msg?
-Nripendra
how to avoid about sort requirement related warning
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 196
- Joined: Tue Nov 23, 2004 11:50 pm
- Location: Sydney (Australia)
Pls recheck. Is it hash partitoned before/in sort stage on the key.
Is the key of the sort stage is same as the key of the remove duplicate stage as well as the partiton mentioned. Not one more or not one less.
Is the same partiton maintained from sort to remove duplicate stage. Is there any change in datatype on the key like unicode, for char to varchar or interger to decimal.....
Is the key of the sort stage is same as the key of the remove duplicate stage as well as the partiton mentioned. Not one more or not one less.
Is the same partiton maintained from sort to remove duplicate stage. Is there any change in datatype on the key like unicode, for char to varchar or interger to decimal.....
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
Also make sure that you specify your remove duplicate with the same details as the sort, so you could sort it in the same order and have one that is case sensistive and the remove duplicate that is not. It will throw that same error because it has detected that the data is sorted differently than the sort stage you specified.
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
-
- Premium Member
- Posts: 196
- Joined: Tue Nov 23, 2004 11:50 pm
- Location: Sydney (Australia)
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact: