h3;ETL的38个子系统/h3;
Ralph Kimball就ETL的各子系统进行了归纳、分类，概括出38个子系统：1、Extract system2、Change data capture system3、Data profiling system4、Data cleansing system5、Data conformer6、Audit dimension assembler7、Quality screen handler8、Error event handler9、Surrogate key creation system10、Slowly Changing Dimension (SCD) processor11、Late arriving dimension handler12、Fixed hierarchy dimension builder13、Variable hierarchy dimension builder14、Multivalued dimension bridge table builder15、Junk dimension builder16、Transaction grain fact table loader17、Periodic snapshot grain fact table loader18、Accumulating snapshot grain fact table loader19、Surrogate key pipeline20、Late arriving fact handler21、Aggregate builder22、Multidimensional cube builder23、Real-time partition builder24、Dimension manager system25、Fact table provider system26、Job scheduler27、Workflow monitor28、Recovery and restart system29、Parallelizing/pipelining system30、Problem escalation system31、Version control system32、Version migration system33、Lineage and dependency analyzer34、Compliance reporter35、Security system36、Backup system37、Metadata repository manager38、Project management system/
ETL示意图：/
img alt="" src="userfiles/30216/1104336917.gif";740)this.width=740" border=undefined;gt;/