incomplete loading of data from Feed file

samyamkrishna · Post by **samyamkrishna** » Fri Nov 03, 2006 4:56 am

I am using datastage 7.1 and 7.5 on two different servers to run the same jobs.

I use the same feed file for a job which is present on both the servers.
the one which is running on 7.1 loads 3300000 records from feed to the table, but its loading only 1300000 records from the feed to the table on 7.5 without giving any errors or warnings.

HELP

kduke · Post by **kduke** » Fri Nov 03, 2006 6:50 am

Call support. I think you found a bug.

gateleys · Post by **gateleys** » Fri Nov 03, 2006 1:37 pm

I had a similar problem while extracting from Oracle9i using OCI9. The extract link only fetched number of rows that were multiples of the array size. It was a bug. When I replaced the OCI9 stage with DRS stage, there was no problem.

The problem, however, did not exist when OCI9 stage was used as the target.

gateleys