We are using Bulk Collect methodology in Database to load the bunch of records at a time.How we will implement the same operation in Datastage. If my source having millions of records, I want to load the bunch of records in to target at a time. How?
You can load the bunch of files at a same time using sequential file stage. In options just select the file location the DB and change the option in the seq file stage to "File Pattern".
Sri
Jul 20th, 2016
Increase the array size in Target Table stage. Also use Parallel Hints while selecting the records.
Implement Bulk Collect methodology in Datastage
Related Answered Questions
Related Open Questions