ETL process的意思|示意

This step also includes ETL process design.

该步骤还包括ETL过程设计。

Even though referential integrity and check constraints are very helpful during the ETL process to help detect data problems, implementing them on final data warehouse tables is not efficient.

在ETL过程中，即时参照完整性和检查约束极其有助于检测数据问题，在最终的数据仓库表中实现它们也不会高效。

A function that converts a timestamp from one locale to another could prove to be a staple in the transformation side commonly found in the ETL process of a data warehouse project.

在数据仓库项目的ETL过程中，将时间戳从一个地区转换为另一个地区的函数被证明是转换方面的主力。

Metadata management: business requirements, data models, ETL process designs, user manuals, and so on.

元数据管理：业务需求、数据模型、ETL 过程设计、用户手册，等等。

A third method is to have the summary tables rebuilt after the ETL process using SQL sum and aggregate functions.

第三种方法是在ETL流程之后使用SQL SUM和汇总函数来重构汇总表。

The mapping specifications themselves are not persisted, which means any changes to the mapping would require to change the ETL code or to repeat the entire mapping process.

映射规范本身不是持久化了的，这意味着对映射的任何更改都需要相应更改 ETL 代码或重复整个的映射过程。