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