Incomplete record read from file
Posted: Tue Jan 16, 2007 11:30 am
Hi:
We are facing an issue with one of our QualityStage jobs
The REALTOR data file contains two columns. The first column [Company_Name] should be 200 characters and the second column [Type] should be 1 character.
I am attempting to standardize the names (Inc. -> Incorporated, Inc -> Incorporated) so I can better dedupe the list.
I attempted to create the definition for the REALTOR file. I created an empty definition for the output file and created a Standardization stage selecting my input and output files. I then created a job and included the reference to my standardization stage. I only included the Company_Name field with the ZQUSZQ literal. However running the job continually resulted in an error. " Incomplete record read from file \xxx\xxx\Data\REALTOR
I also ran the job with only the first column in the source file but still ended up with the same error. I checked the metadata definition to match with the data file. Also there are no blank spaces or lines at the end of the file to cause this error.
Thanks
We are facing an issue with one of our QualityStage jobs
The REALTOR data file contains two columns. The first column [Company_Name] should be 200 characters and the second column [Type] should be 1 character.
I am attempting to standardize the names (Inc. -> Incorporated, Inc -> Incorporated) so I can better dedupe the list.
I attempted to create the definition for the REALTOR file. I created an empty definition for the output file and created a Standardization stage selecting my input and output files. I then created a job and included the reference to my standardization stage. I only included the Company_Name field with the ZQUSZQ literal. However running the job continually resulted in an error. " Incomplete record read from file \xxx\xxx\Data\REALTOR
I also ran the job with only the first column in the source file but still ended up with the same error. I checked the metadata definition to match with the data file. Also there are no blank spaces or lines at the end of the file to cause this error.
Thanks