Hi clever guys
I have two tables named dbo.jade.store and dbo.stage.Store. The first has a column called store_number, PK smallint, not null and the other storeNumber, PK, INT not null.
For some reason I cannot use a derived column or data conversion to change the store_number from smallint to int as the mapping won't work in the SCD.
Can anyone tell me what I'm doing wrong apart from being stupid?
Kind regards
Fred