以这种方式控制ETL工作,对于保证按适当次序装载包含主键或外键依赖的数据仓库表十分有用。
Controlling the ETL work in this manner can be useful for guaranteeing the proper sequence for loading data warehouse tables that contain primary or foreign key dependencies.
确保参照完整性(referential integrity, ri)关系中的依赖表拥有与外键匹配的索引。
Ensure dependent tables in a referential integrity (ri) relationship have indexes that exactly match the foreign key.
例如,如果存在依赖表(例如表中有一个外键,该外键引用数据要被装载到的目标表),那么这些表可能被设为CHECK PENDING状态。
For example, if there are any dependent tables (tables that have a foreign key referencing the table into which data is to be loaded, for example), they might be placed in the CHECK PENDING state.
应用推荐