I need some help from the wM Experts as I am stuck on this!!!
I got the following:
–LOOP /filenameList (go over every file in dir)
----MAP (loads Document List from Record1)
—SQLBatchInsert (adapter services inserts data into Oracle)
Somehow I need to create a document list of 5,000 records at a time so the BatchInsert will do SQL insert of only 5,000 records at a time. So for example. If Record1 LOOP will have 10,000 I need to split that into 2. So the loop will load the document list with first 5,000 records then do the insert then go back and load the document list with remaining 5,000 records out of the initial 10,000.