DSXchange

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

Search here for "has import error and no default value"

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

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.