What is the role of change data capture in ETL processes?
- Aggregating data for reporting purposes
- Capturing and tracking changes in source data over time
- Encrypting data during transfer
- Indexing data for faster retrieval
Change Data Capture (CDC) in ETL processes involves identifying and tracking changes in source data over time. This allows for the extraction of only the modified data, reducing processing time and ensuring data accuracy in the target system.
Loading...
Related Quiz
- Which technique is best for dealing with outliers in a dataset?
- In the context of cloud computing, what advanced technology is often integrated with big data platforms for predictive analytics?
- In advanced data analytics, _______ is crucial for making predictions based on historical data.
- _________ in Tableau provides a powerful way to create complex calculations and data transformations.
- What is the primary function of a Database Management System (DBMS)?