Forum Discussion
Solved
Microsoft Fabric Copy Job – SCD Type 2 (SCD2) Issues
During source data changes, the Copy Job does not manage correctly the SCD2 control colums: copyjob_valid_from, copyjob_valid_to, copyjob_is_current. As shown in the results, the first two rows c...
Hi D4zk,
Since MERGE (SCD Type 1) is functioning while SCD Type 2 is not, this highlights the documented difference: SCD2 uses CDC-based historical tracking, including expiring rows and soft deletes, whereas MERGE updates only current data. SCD2 depends on CDC to handle inserts, updates, and deletes during incremental runs, so its behavior varies based on how those changes are applied. As your configuration has been validated, you can keep using MERGE for stability or consider submitting a support request for SCD2-specific issues.
Change data capture (CDC) in Copy Job - Microsoft Fabric | Microsoft Learn
Hi D4zk,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.