Efficient Slowly Changing Dimension type 1 in : separate INSERT detection port (record doesn't exist on target) from UPDATE port (check all columns for changes) and evaluate them separately in Filter Transformations. Benefit: generated query for INSERT will not have complex WHERE condition which UPDATE uses.

Mastodon.lt

Mastodon node run by Inretio, MB.