Adobe Interview Question

Not very in Depth question but relevant tlike How to do a type 2 dimension using Merge in SQL