Multiload

Database
Enthusiast

Multiload

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

4 REPLIES
Enthusiast

Re: Multiload

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
Teradata Employee

Re: Multiload

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.

Enthusiast

Re: Multiload

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

Teradata Employee

Re: Multiload

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.