The only way is to make your ETL more complicated by introducing some
sort of suppression table and swapping out the final table/view
feeding your dimension so AS never sees this record.

You're basically building a filter or lens through which your OLAP
system sees your OLTP data, and changing the picture that AS sees.

On Sep 28, 2:58 pm, "Joe" <hortoris...@gmail.dot.com> wrote:
> We had to manfully correct a couple records in our data mart - but don't
> have the luxury of changing the source OLTP tables.
>
> What is the best approach to prevent the ETL to pick this change us as a SCD
> entry and move back the data correction to be in line with the source
> tables?