All Forums Database
abhishank18 12 posts Joined 03/16
27 Jul 2016
Multiload

Does Multiload use worktables while performing Delete tasks ? I see two contradicting statements in multiload reference document. Please confirm.

Abhishank
M.Saeed Khurram 544 posts Joined 09/12
27 Jul 2016

Hi,

There are a few differnces between Mload Import task and delete task. 

In the delete task there is no acquisition phase, only application phase is used to delete rows. So there is no worktables to hold the imported data.

There are only 3 work subtables in application phase used to update NUSI, CheckPoint and DML operations.

Khurram

ToddAWalter 316 posts Joined 10/11
27 Jul 2016

There are two different forms of delete in Multiload which may be the source of confusion.
 
Multiload Delete Task accepts a DELETE statement with a where clause intended to bulk delete the rows qualified by the where clause. It does not import any data so does not have a work table like other Multiload operations. The advantage of using this over a normal SQL Delete Where is that it is not journalled but is restartable (can't be rolled back but can be finished).
 
Multiload also has a delete where a list of keys is provided from an external source to identify specific rows to delete. This form imports the list of keys to a work  table, then performs the delete during the apply phase. The work table in this case contains just the imported keys.

abhishank18 12 posts Joined 03/16
01 Aug 2016

Can you please elaborate second point where keys are provided from an external source ? How does the external source provides values ?

Abhishank

ToddAWalter 316 posts Joined 10/11
01 Aug 2016

The same way any data is loaded. A souce is decribed that contains the PI values to delete and multiload is told to load those PIs and then use them to delete rows.

You must sign in to leave a comment.