Forgive my lack of warehouse knowledge but the current flag, will that be something I define during view creation or its something expected to be in the original table?

Thanks very much, let me tinker with it , I think the type -2 SCD seems more plausible.