Skip to Content
0
Apr 08, 2010 at 06:58 AM

split logic when loading slowly changing dimensions

69 Views

Hi everyone,

I know when loading slowly changing dimensions you load as follows:

source -> Table comparison -> History preseving -> Key generation -> target;

What if now when loading I want the following:

For a changing dimension, I need to do something;

For a historical dimension, I need to do something else;

For a brand new one, I need to do something total new.

How can I achieve this? I want to split my logic and cater for all 3 scenarios and run scripts for each splits.

Thanks and regards,

Edited by: gsecure on Apr 8, 2010 9:07 AM