Implement Bulk Collect methodology in Datastage

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?

Showing Answers 1 - 2 of 2 Answers

Pavan Kumar

  • Jul 8th, 2016

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".

  Was this answer useful?  Yes


  • Jul 20th, 2016

Increase the array size in Target Table stage. Also use Parallel Hints while selecting the records.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions