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.

· · Web · 0 · 0 · 0
Sign in to participate in the conversation

Mastodon node run by Inretio, MB.