I have been searching a while for some concrete explanation on the requisite of the Prefetch Row Count and Prefetch Buffer Size property of an Oracle Connector stage , but wasnt able to find any ?
Can anyone please guide me on the signifcance of these two features of the stage ?
As far as the IBM Infosphere online manuals go , the number of rows fetched / written by an Oracle connector stage per batch = Prefetch Row Count + Array Size
Whats the neccessity of using the Prefetched Rows then if I can have the number of records to be fetched specified in the Array Size property ?
Thanks
Kumarjit.
Pefetch Row count in Oracle Connetor stage
Moderators: chulett, rschirm, roy
Pefetch Row count in Oracle Connetor stage
Pain is the best teacher, but very few attend his class..