handling an update of your data warehouse when a record (or a line on a transaction) gets deleted in NS can be tricky