10 ms·
No one does just "ETL" anymore - ELT/ETL are more or less synonymous now. I can't remember the last time I talked to a team that was throwing data away anymore
by tomnipotent 7y ago
No one does just "ETL" anymore - ELT/ETL are more or less synonymous now. I can't remember the last time I talked to a team that was throwing data away anymore because of storage constraints. It's a straw man in 2019.
C-store doesn't solve for denormalization or provide any advantages when you're copying data all over the place to avoid joins.
- thingsilearned 7y ago1. It is - and that's why I chose that example (a less controversial one) here. And though ELT is a very common standard now - I don't know of a single book that recommends it or explains why that change has happened. Just one of the reasons for writing a new data book. 2. C-Store does largely solve pervious performance and cost issues with denormalization. We also write a bit in this book (more to come) on how to avoid doing all that copying.
- deleted 7y ago[deleted]