ELT & ETL
The ELT method provides a modern alternative to ETL, but in some cases we need to use ELT. ELT should be used in various situations instead of ETL, they are:
Use ELT when the data volume is high. When both the source and target databases are the same. When the database engine is well adapted for processing, such as PDW, with the help of ELT, it is easy to quickly load a large amount of data.
— Fugui，Data engineer、Machine learning Engineer、Software Engineer.