the job has its finished but no records are loaded into the file.
the delimiter is pipe as there is no symbol of pipe I used "|" in the field defaults --delimiter.
when i view the log I see the below warnings
Sequential_File_38,0: Field "EntityID" has import error and no default value; data: <empty>, at offset: 9
Sequential_File_38,0: Field "FIRST_NAME" delimiter not seen, at offset: 55
please help me with a solution for this
Reading data from a PSV file
Moderators: chulett, rschirm, roy
Reading data from a PSV file
Thanks,
Surya
Surya
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
Re: Reading data from a PSV file
These tell me that the Sequential file stage is not properly configured to read the data. Please check that, use View Data to make sure if you done so correctly.suryadev wrote: Sequential_File_38,0: Field "EntityID" has import error and no default value; data: <empty>, at offset: 9
Sequential_File_38,0: Field "FIRST_NAME" delimiter not seen, at offset: 55
Vivek Gadwal
Experience is what you get when you didn't get what you wanted
Experience is what you get when you didn't get what you wanted