ETL(Extract-Transform-Load)是构建数据仓库的重要一环,主要包括()。
A.抽取
B.转换
C.加工
D.加载
A.抽取
B.转换
C.加工
D.加载
Describe how to estimate the load time of a large ETL job.
Real Time ETL
简述如何评估大型ETL数据加载时间。
Outline some challenges faced by real-time ETL and describe how to overcome them.
简述实时ETL的一些难点及其解决办法。
At which stage of the ETL should data be profiled?
简述应该在ETL的哪个步骤来实现概况分析?
What are the essential deliverables of the data quality portion of ETL?
ETL项目中的数据质量部分核心的交付物有那些?
What are the four basic Data Flow steps of an ETL process?
在ETL过程中四个基本的过程分别是什么?
Describe the different types of ETL metadata and provide examples of each.
举例说明各种ETL过程中的元数据。
Name the three fundamental fact grains and describe an ETL approach for each.
简述三种基本事实表,并说明ETL的过程中如何处理它们。
What steps do you take to determine the bottleneck of a slow running ETL process?
如果ETL进程运行较慢,需要分哪几步去找到ETL系统的瓶颈问题。