Yes if u upload video with version flag and timestamp that would be better bcj no1 is using isactive only and in my scenario I have 300 columns so I can't right that much big isnull n not isnull logic so pls suggest easy approach and upload new video.. appropriate in advance
This is so easy to accomplish in SSIS. Why is it still so cumbersome in ADF?
Yes if u upload video with version flag and timestamp that would be better bcj no1 is using isactive only and in my scenario I have 300 columns so I can't right that much big isnull n not isnull logic so pls suggest easy approach and upload new video.. appropriate in advance
Soon, I'll upload one more video on the same with start and end date
@@ssunitech6890 better u can add date and version and flag together
HI BRO i try 2-3 times but doesn't get 0 flags old record its all show 1 in active column
Watch the video step by step and try to implement, there should be something wrong that you are doing.
Where are startDate, endDate, and Surrogate Key columns? These are SCD2‘s key factors, not isActive...
That you will see in next video