Talend also does an excellent job for ETL and ELT. You can take a look at this page on my website: http://www.hiregion.com/2010/01/data-loading-through-talend-etl-studio.html and related articles. I have also loaded hundreds of thousands of rows to millions through MySQL bulk loading (LOAD DATA INFILE syntax - dev.mysql.com/doc/refman/5.1/en/load-data.html ) and then doing some transformations in MySQL. You can do most of transformations before the load (ETL) or after load (ELT) or use hybrid technique.
发布评论
评论（2）
Pentaho Kettle (PDI) 是开源的，它有一个社区版本，效果很好。
Pentaho Kettle (PDI) is open source and it has a community version here, which works quite good.
Talend 在 ETL 和 ELT 方面也做得非常出色。您可以在我的网站上查看此页面： http://www.hiregion.com/2010/01/data-loading-through-talend-etl-studio.html 及相关文章。我还通过 MySQL 批量加载（LOAD DATA INFILE 语法 - dev.mysql.com/doc/refman/5.1/en/load-data.html）加载了数十万行到数百万行，然后在 MySQL 中进行一些转换。您可以在加载之前 (ETL) 或加载之后 (ELT) 执行大部分转换，或者使用混合技术。
Talend also does an excellent job for ETL and ELT. You can take a look at this page on my website: http://www.hiregion.com/2010/01/data-loading-through-talend-etl-studio.html and related articles. I have also loaded hundreds of thousands of rows to millions through MySQL bulk loading (LOAD DATA INFILE syntax - dev.mysql.com/doc/refman/5.1/en/load-data.html ) and then doing some transformations in MySQL. You can do most of transformations before the load (ETL) or after load (ELT) or use hybrid technique.