Hi I am reading the data from file and my requirement is to use merge stage. I need to validate the file aganest two refference tables.
so I took the merge stage then I have connected the input stage to the merge and selected the key columns. Then added both reference tables to the merge.
Job gets compiled successful. But if I run the job I am getting the following errors
cs}}}(1): Error when checking tsort: Sort key field not found: MKT_SGMNT_CD
subArgs={asc}}}(2): Error when checking tsort: Sort key field not found: SIC
Merge_38: Error when checking operator: On input data set 1: Could not find input field "MKT_SGMNT_CD".
Error when checking operator: On input data set 2: Could not find input field "SIC".
main_program: Could not check all operators because of previous error(s)
I am getting these 4 errors. I have changed the partition to hash but no use. I getting the same error.
Please help me on this.
Merge stage error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 91
- Joined: Wed Apr 20, 2005 7:59 pm
- Location: U.S.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Sort key field not found usually indicates an issue with the metadata rather than with the partitioning.
Check every link thoroughly to make sure that the sort key column is present on that link.
Check every link thoroughly to make sure that the sort key column is present on that link.
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.