Skip to Content

How to clear IBP staging table before loading?

Jun 13, 2017 at 02:46 PM


avatar image

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.

df-delete.png (10.4 kB)
df-batch.png (41.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member
Jul 20, 2017 at 03:02 PM

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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