Another (and not ideal) work-around if you wish to use the existing transformation: - specify %let etls_debug = 1; in your job(s), or perhaps in appserver_autoexec_usermods. - Have program (macro preferably) in your postcode of your SCD2 transform (or as a separate transformation) that picks up work.etls_close, modify the end date (for records equal today - drop the rest), and re-apply it to you target table. Of course, if you are expecting a big amount of records to be closed out each batch, this is probably not acceptable from a performance standpoint.
... View more