We are using BIX to extract the work instance from work table. We have one stage schema where we have a replica of work table. When BIX job run we are populating the stage work table. We noticed that for some work instance for a particular date BIX table is containing duplicate work instance, whereas BIX job is running only a day. Is that someone already faced this issue? For a particular day BIX should extract only single instance of work. Is that some a Product issue?
Please refer to BIX design models page. If you go down to the section "Designs for different table models", you will notice the delete query to use for "transaction table". This could be one way to handle this.
In future, we may handle this in the BIX product but currently there is no OOTB functionality to do this.