Fraser: Post-load master data management in the warehouse is safely non-destructive
George Fraser · Fireside Chat: George Fraser (Founder & CEO, Fivetran) with Matt Turck (Partner, FirstMark) · Sep 18, 2020 · at 44:46
George Fraser, Founder and CEO of Fivetran, explains the architectural advantage of decoupling data replication from governance transformations like deduplication.
0:00 / 0:36exact quote · 36.2s
▶ Watch the full episode on YouTube → 720p mp4 · rendered on demand · StarZero watermark
“And this is different than how it's historically been done, but the big advantage of Doing MDM and other similar things in this way is that it's non-destructive. So you still have the original data. If you make a mistake and you realize later, oh, I said these were the same person, but they're actually not. They're two different people. And maybe like that data has since been deleted from Salesforce. So it's not even there anymore. It's still possible to recover the original data because you're doing it like in two steps. Five tran copies. And then you modify and you write out to a different set of tables.”
quote is from the automated transcript, cleaned for reading: filler sounds and stutters are removed, nothing is rephrased. names can be misheard (the analysis reads context, assessments check outside sources). how →
More from George Fraser
Fraser: Fivetran succeeded by guaranteeing data accuracy instead of selling toolkits
“And the really critical thing we did that laid the foundation for our eventual success was that we said that it was our responsibility to make the data match. Which is actually unusual in the field of data integration. Most data integration tools, they see the…”
Fraser: Hypergrowth forces quicker venture rounds regardless of capital efficiency
“No matter how capital efficient you are, you end up the faster you grow, the sooner you need to raise again, unless you want to just sit there and have, you know, one month's payroll in the bank account, which I don't think you want to when you have a lot of e…”
Fraser: Syncing a single database can support an entire company
“You can make a whole company just out of syncing one database”
Fraser: Cloud data warehouses render legacy tools like OLAP cubes obsolete
“The tools that you use to manage data and analyze data are actually getting simpler over the last 10 years. You don't need as many different things because a few tools, most importantly the data warehouse, Have gotten so much better over the last 10 years that…”