Challenge #80: Slowly Changing Dimensions

[daniel_ferreira]

Follow my solution attached...

[jwlong91]

Such a cool challenge!

[JonM]

Having implemented slowly changing dimension in other programs, Alteryx has made this quite simple.

[Tom_Pilgrem]

Got a bit stuck on this one so had a sneaky peek to help me out! Good exercise and learnt how to handle some new things such as if people/customers are current or not. 

[Wouter]

My solution:

Spoiler

[Ruud]

Didn't want to use a join if we don't need one.

[akshatoz]

Are you generating surrogate keys?

[StevenBetts]

Here's my solution!

Spoiler

[danilang]

A suitable Padewan challenge, this was.  No Fear, could I sense within it

Spoiler

yoDan

[Aster]

Spoiler

I must be complicating issues...Will take a look at what others do.

Also, there seems to be a discrepancy here. In the solution provided inside start file, Bob's record is erased from archieve, but in the solution file, it is retained with a current flag of Y.