Slowly Changing Dimension

[Anonymous]

I'm trying to figure out what to do for this SCD.

Any ideas would be greatly appreciated.

I've loaded my data below.

[hic]

You should use %_DateKey. But first you need to interpret the dates in the interval table as dates, e.g. through "Date#(StartDate,'YYYYMM') as StartDate". See attachment for a complete load statement.

HIC

[Anonymous]

thanks, works great.

What about this? I don't know why it's not recognizing %_DateKey in this table now just below the interval match

PharmacyKeyTable:

LOAD

      PharmacyName & '|' & %_DateKey as PharmacyXDate,

      PharmacyName & '|' & StartDate & '|' & EndDate as PharmacyXInterval

resident SalesLocationTmp;