Posted: Tue Mar 24, 2009 12:29 am
Hi
Enter the correct format in sequential file
as u said that all records are loaded but in logs it is saying that one record is rejected, this is because, at the end of file they entered one empty line , so all records are loaded into the target and one line is not loaded because of not finding any delimiter, this is purely the "final delimiter format mismatch" in sequential file
and for avoiding charater at the end of each line, set the record delimiter format
Enter the correct format in sequential file
as u said that all records are loaded but in logs it is saying that one record is rejected, this is because, at the end of file they entered one empty line , so all records are loaded into the target and one line is not loaded because of not finding any delimiter, this is purely the "final delimiter format mismatch" in sequential file
and for avoiding charater at the end of each line, set the record delimiter format