Slowly Changing Dimensions (SCD) and Change Data Capture (CDC) are two important concepts in the #data world. But what do they really mean, and how do they differ from each other? It is also a question asked in data engineering interviews. So, let’s discuss.
SCD is like trying to keep track of the email addresses we create over the years. Just like how we change email addresses, the data also changes over time. SCD helps us keep track of these changes in a way that makes sense and allows us to understand the history of our data.
CDC, on the other hand, is like having a personal assistant who tells us every time we change our email address. It’s a process that captures and records any changes made to the data and sends us updates in real-time.
In a nutshell, SCD is like keeping a historical record of the data, while CDC is like getting real-time updates on any changes made to that data. Together, these two concepts help ensure that the data is correct and up-to-date so that the team can make decisions based on accurate information.
If you often open multiple tabs and struggle to keep track of them, Tabs Reminder is the solution you need. Tabs Reminder lets you set reminders for tabs so you can close them and get notified about them later. Never lose track of important tabs again with Tabs Reminder!
Try our Chrome extension today!
Share this article with your
friends and colleagues.
Earn points from views and
referrals who sign up.
Learn more