Thanks for the link, very informative. However, at my current project I'm not allowed to install custom components, so yeah 🙂

Correct me if I'm wrong, but to me it seems that the set-up that you outlined just makes a perfect copy of the staging table in the base table. (rows that are not in the staging table are deleted, rows that are not in the base table are inserted, changed rows are updated. Hence, you end up with the staging table).

Isn't it simpler to just truncate the base table, perform a load of the staging table and re-build indexes?

(or did I miss something. That's possible, it's friday :-))