The purpose of SCD 2 is to track all the history of changes, when you send the new same row, the new row will not be inserted because you already have that row in your target and this is the normal behaviour because only few rows gets changes , remaining all are old rows only
Very well explained Hetu.
Nice session. Thank you so much.
👍 Very Good learning session.. I follow you from couple of years. I need to connect with you, how can we connect?
Please send email sahu.hetram@gmail.com
In SCD2 , if we insert same row with same data can it insert ? or not?
The purpose of SCD 2 is to track all the history of changes, when you send the new same row, the new row will not be inserted because you already have that row in your target and this is the normal behaviour because only few rows gets changes , remaining all are old rows only