27 May 2010

Remove Duplicate and Sort Warning Message

Error Message:
rmd_msisdn_y: When checking operator: User inserted sort "srt_EFF_DT" does not fulfill the sort requirements of the downstream operator "rmd_msisdn_y"




Cause:
1. Remove duplicate key does not include in Sort Key.
2. Partition key in Remove Duplicate stage and Sort Stage is not identical.




Solution:
Insert more sort key. Choose the SAME partition method.


No comments: