SCD TYPE 2

sainath · Post by **sainath** » Thu Mar 23, 2017 8:23 pm

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

leandrohmvieira · Post by **leandrohmvieira** » Fri Mar 24, 2017 5:38 am

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.

chulett · Post by **chulett** » Fri Mar 24, 2017 7:47 am

Out of curiosity, are you planning on using the SCD stage or "rolling your own" logic?