Change Data Capture (CDC) is the method of developing ETL processes to propagate changes in the source system into your data warehouse for dimension tables.
CDC is directly related to another DWH concept of Slowly Changing Dimensions (SCD), the dimension tables that data changes constantly throughout the life of data warehouse.
A good example would be the Employee
dimension table, which holds data on the employees in your company. As you can imagine, this table is in constant flux: new employees are hired and some employees leave the company, change positions and roles, or even transfer between departments. All these changes have to be propagated to an Employee
dimension table in DWH from the source systems, which always store only the latest state of the Employee
data. In DWH, in most cases, for most of the dimension tables, you want to keep the historical data to be able to derive the state of the Employee
data at a specific point of time in...