DW_Batch on incremental and history tables

When finding the last DW_Batch number on incremental or history tables the current implementation is hard on performance since a table scan is done on the _V table. To improve performance I suggest we create a table for storing the last value of the DW_Batch number, i.e. <TableName>_B, and get the batch number from this table instead of scanning the _V table for the number.

The implementation is similar to the _I implementation for incremental tables.

1 comment

Please sign in to leave a comment.