SCD2 using merge statement - any experiences?
893411Dec 10 2011 — edited Dec 10 2011Hi,
Recently, I read about a very nice method how to impelement SCD2 using the oracle merge statement (http://forum.kimballgroup.com/t11-how-to-load-a-slowly-changing-dimension-type-2-with-one-sql-merge-statement-in-oracle)
Currently we are using an ETL tool to accomplish that, which is a pretty complex mapping for such a simple task and it's also quite slow. I am thinking about replacing the SCD2 implementation using the merge-statement.
Before I start with that, I wanted to ask you if there are any downsides or risks with the merge-statement approach I don't see yet. One table contains up to several millions of rows and we have more than 200 tables. Will the merge perform slow when the target table is very large? We expect only a small percentage of daily updates/inserts.
Thanks for your opinion oder experience with the merge statement!
Edited by: 890408 on Dec 10, 2011 10:35 AM