How to clear IBP staging table before loading?

[former_member207428]

Question : How can we clear the contents of the IBP staging table?

In the Data Flow options, there is the possibility to check ‘Delete data from table before loading’, but this option is in our flows always greyed out.

In the execution properties of a flow there is also the global variable $G_BATCH_COMMAND by default set to ‘INSERT_UPDATE’. Setting this to 'DELETE' makes no change.

[virendrakumar_soni · Accepted solution]

Delete data from table before loading is not supported for IBP as target, it only works for Database as the target.

You need not to worry about the data in staging as the every batch has a different batch ID and it doesn't matter if the staging table has any data in it or not. Staging table automatically cleans if the job has been completed(even with data integrity errors.

[former_member207428 · Accepted solution]

Thanks, that was the feedback we also received from our customer message.