Lets say there is a table schema where in the columns are a,b,c,d,start_time,end_time,current_status. Can we have a,b,c as SCD columns and let d not be a part of SCD logic so that if d changes, it won...

I am using Data vault 2.0 model. Here we are not supposed to use UPDATE in a table. Normally in RDBMS, we implement SCD-2 using UPDATE & INSERT strategy. But in my case, I can use only INSER strat...