Hey i dont understand one thing about SCD Type 3. Do we add 'Previous value' for every atrribute of every dimension if keeping last record is a business need? like anna changed her name, gary could change his cell no and john could change his address.
You add "Previous value" to every attribute you want to track using SCD Type 3. Depending on your case it might be a single attribute per table, or multiple ones.
You've explained SCD's very clearly and succinctly, thank you so much!
Thanks Tybul for this great video on SCD!!
Great video!!
Hey i dont understand one thing about SCD Type 3. Do we add 'Previous value' for every atrribute of every dimension if keeping last record is a business need? like anna changed her name, gary could change his cell no and john could change his address.
You add "Previous value" to every attribute you want to track using SCD Type 3. Depending on your case it might be a single attribute per table, or multiple ones.
I was asked this question in interview - how to implement SCD in datlake or data warehouse!! Thanks for addressing this
You are welcome!
damn anna has a complicated life
Yeah, that's just how life is. But at least we can learn something because of her.
how many more videos before you complete this playlist?
About 20.