Your way of explaining each and everything makes you different from everyone...you are doing to great for us

@cloudanddatauniverse

Ай бұрын

Thank you, glad to know

Nice! Sir, For SCD-2, do we really need to have StartDate, EndDate, and IsActive ? Once we are setting-up/updating EndDate, isn't it automatically an end to that record for maintaining record history? Later on, if we need to pick the record we will pick only those records wherever EndDate is still null for all active records, and picking up inactive records wherever EndDate is not null

@cloudanddatauniverse

Ай бұрын

Thanks for watching. The start date and enddata will ease future calculations, lets say i want to see period of activeness for each record, then i can simply subtract enddate from start date and such more things which ease our development.

@VictorBoney

Ай бұрын

@@cloudanddatauniverse Yes, that's right. However, I was getting inquisitive about whether or not "IsActive" as an additional column is really required when we already have Start Date and End Date specifically for SCD-2.