Skip to Content

How to clear IBP staging table before loading?

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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.

    Add comment
    10|10000 characters needed characters exceeded