Change data capture is a Microsoft SQL Server technique used to improve the efficiency of ETL by tracking and identifying record inserts deletes and updates
I designed this pattern and approach to satisfy the client requirements for all ETL pipelines. As the project and the team grew, I created videos to teach our new in-house developers also to ensure that the offshore Indian development team were aware and using same approach and coding patterns as the head office.