1
Vote

Error without SCD1 transformations

description

Hi Kamiln

If you haven't SCD1 transformations (only SCD0 for existing records) the code it's not generated.

I'm using this technic to load a fact table.

A workaround is to use one SCD1 transformation and after that change the code generated.

Regards,

Ramon

comments

kamiln wrote Mar 22, 2016 at 10:46 PM

Hi Ramon,
Thank you for your message.
I'm not sure what you want to achieve.
SCD0 doing nothing. However if you want to use MERGE as a typical scenario (INSERT/UPDATE) - I would suggest to use SCD1 because doesn't keep the historical data and overwrites existing data on the target or creates new ones.
Hope that help.
Cheers,
Kamil