Post reply

Periodic Snapshot Surrogate Keys

  • August 1, 2018 at 5:40 am

    #366896

    Hi

    I am implementing a periodic snapshot for inventory levels. When implementing surrogate keys, should these be applied to every snapshot take (eg. the entire dataset is updated with the current SK) or just the current day's snapshot?

    Thanks

  • August 1, 2018 at 5:54 am

    #1999854

    spin - Wednesday, August 1, 2018 5:40 AM

    Hi

    I am implementing a periodic snapshot for inventory levels. When implementing surrogate keys, should these be applied to every snapshot take (eg. the entire dataset is updated with the current SK) or just the current day's snapshot?

    Thanks

    A bit more context would be useful.
    What do you use the snapshots for?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply