On the face of it, using ELT and capitalizing on all the advantages listed above might seem like a no-brainer. But things are rarely that simple. Although ELT is new(er) and exciting, there are plenty of reasons that ETL has been the standard in data processing for so long.
For intensive transformations that rarely vary, data that contains a wealth of personal identifying information (PII), or systems built around legacy architecture, ETL remains a strong choice…even if that may change as ELT continues to evolve.
When it comes to ETL vs ELT, 'which is better' really comes down to the external factors you have to consider and needs of the business.