ETL or ELT? The Big Data age calls for the right integration strategy - ET CIO

By Vikram Labhe It is a truism at this point to talk of the centrality of data for organisations. According to IDC, the global datasphere will rise at a compound annual growth rate (CAGR) of 23% between 2020-2025, highlighting the importance of responding to the surge in storage demand. For businesses to leverage data insights and drive growth, they must coordinate the dependencies and execute the different tasks on their data journey in the desired order, all while ensuring minimal impact from potential errors. Whether an organisation favours extract, transform, load (ETL) or extract, load, transform (ELT) will depend on their specific needs. Orchestration is fundamental for modern data processes, but for many businesses a modern data stack makes specific orchestration tools redundant.