Page 1 of 1

SCD TYPE 2

Posted: Thu Mar 23, 2017 8:23 pm
by sainath
Hi

i have to implement SCD type 2 for 20 dimensions .

Is it possible to create shared container of scd type 2 logic inbuilt

and how to pass the type 2 columns dynamically .

let me know if it is possible

thks

Posted: Fri Mar 24, 2017 5:38 am
by leandrohmvieira
I dont think it's possible, SCD involves several variables that do not apply as common logic like DBSequence or filepath for each dimension, purpose codes, source data and transformations.

Posted: Fri Mar 24, 2017 7:47 am
by chulett
Out of curiosity, are you planning on using the SCD stage or "rolling your own" logic?