Can some one tell me what is the use of commit every in tOracleOutput?? I have set that to 10 and ran the job and it is not populating anything in target even though the records are available in source .
Hi The option "Commit Every" is used to ensure transaction quality and performance. The issue you got is not due to "Commit Every". There must be other wrong points. Regards, Pedro
Still not clear.... if i set commit every to 10 records will it only populate 10 records in the target or it will populate all the records but commit 10 records at a time??
The latter but possibly commit each 10 records sent to tOracleOutput at a time not each 10 records accepted by Oracle i.e. if 9 out of 10 reject, 1 will be committed each time.
