ETL and ELT

ETLIs the abbreviation of extract-transform-load. It is used to describe the process from the source end to extract (extract), transpose (Transform), load (load) to the target end.ETLThe term is commonly used in data warehouses, but its objects are not limited to data warehouses.

Directory [Hide] 1 ETL and ELT 2 tools 3. See 4. External Connection

[Edit] ETL and ELT

ETLThe process described generally includesETLOrELT(Extract-load-transform) and mixed use. The larger the data volume, the more complex the conversion logic, and the database with a strong computing capability on the target end, the more I prefer to useELTTo use the parallel processing capability of the target database. Talent

[Edit] Tool

ETL(OrELT) The process can be developed using any programming language. Because ETL is a very complex process and handwriting programs are not easy to manage, more and more enterprises are using tools to help.ETLAnd use its built-in metadata function to store mapping and conversion rules of the source and target.

The tool also provides powerful connection functions (connectivity) to connect the Source and Destination. Developers do not have to familiarize themselves with different platforms and data structures and can develop them.

Of course, for these benefits, the price is money.

 

From: http://zh.wikipedia.org/wiki/ETL