Last Record is Missing

s_r_chandru · Post by **s_r_chandru** » Fri May 21, 2004 3:09 am

Hi
Ken,
We have issue in Sequential File stage,I try to write a 500000 record from the source to target both sequenctial file doing two hash file lookup(No constrains),The issue is that,the last record is missing in the target which is present in the source((In Unix i use the tail command to view the last record in the source and the target )) we are wondering how come.But there is no log no warning at all,In the director when I monitor it shows all record written to the file but when I go physically and check i could not get the last record is there any work around for it, eagerly looking towards your reply

Thanks,
-Chandru

ketfos · Post by **ketfos** » Fri May 21, 2004 9:25 am

Hi,
You may do addtional check to find the missing record.
1. Try using @OUTROWNUM System variable in the transformer while writing in the sequential file. This is incremental number and will give you record count in the output seq file.
2. Try using another link in the transformer which will write the reject records.

These two will help in finding the missing record.

Thks

Ketfos

ray.wurlod · Post by **ray.wurlod** » Fri May 21, 2004 5:42 pm

Chances are that the final line in the source file is missing its end-of-line character, and your DataStage job specifies UNIX style end-of-line markers.

s_r_chandru · Post by **s_r_chandru** » Sun May 23, 2004 9:27 pm

Thanks Ray,
I found that the problem is in the RowBufferring ,Once I disable it i could get the Last record,Ray did you come with this problem anytime regarding rowbuffering

-Chandru

chulett · Post by **chulett** » Sun May 23, 2004 10:02 pm

If you search the forum, you'll find that there have been several recent conversations regarding Row Buffering and the strange problems it can cause.