ETL job details and operational metadata.
ETL作业详细信息和操作元数据。
There are several ETL tools on the market.
市面上有几个ETL工具。
This step also includes ETL process design.
该步骤还包括ETL过程设计。
ETL of short-term history snapshot and configuration data.
短期历史快照和配置数据的etl。
The issue needs to be addressed with a scalable ETL architecture.
这个问题需要用一个可伸缩的ETL架构来解决。
What are the four basic Data Flow steps of an ETL process?
在ETL过程中四个基本的过程分别是什么?
Extract, Transform, and Load (ETL) technologies can be used here.
可以在此处使用提取、转换和加载(Extract, Transform, and Load,ETL)技术。
An ETL developer, who is responsible for ETL design and development.
ETL开发人员,负责ETL设计和开发。
First, the ETL places a significant load on your production databases.
首先,ETL给生产数据库增加了明显的负担。
This made the test more realistic by mimicking a real world ETL scenario.
这种测试更切合实际,酷似一个真实的ETL场景。
After all, the acronym ETL stands for Extraction, Transformation and Load.
毕竟,首字母缩写词etl代表提取、转换和加载。
Data propagation: ETL process to aggregate and enhance data for data marts.
数据传播:用于为数据集市聚集和增强数据的ETL过程。
A custom data warehouse has very few edits for data loaded during the ETL process.
定制的数据仓库在ETL过程中对装载的数据进行的编辑非常少。
As you might expect, there are several ways to program an ETL job for this scenario.
正如您所预料的,有多种方式为本场景编写ETL任务。
Figure 25 shows a sample ETL job that illustrates the TDEE data extract and load features.
图25所示的示例ETL作业演示了TDEE数据提取和加载特性。
Figure 27 shows a sample ETL job that illustrates the TDMLOAD data export and load features.
图27所示的示例ETL作业演示了TDMLOAD数据导出和加载特性。
The study on the approach of ETL is one of the most important parts of data warehouse research.
在数据仓库的建设中,ETL流程的实现是最复杂的工作之一。
Once you understand the ETL process, you can apply the same process to other database environments.
一旦理解了ETL过程,你可以在其他的数据库环境中应用相同的过程。
Metadata management: business requirements, data models, ETL process designs, user manuals, and so on.
元数据管理:业务需求、数据模型、ETL过程设计、用户手册,等等。
In this section, a simple ETL job is designed to illustrate the design steps and the extract functions.
本节将设计一个简单的ETL任务,以演示设计步骤和提取功能。
Generally, ETL processes manually specify when to update MQT rather than allow this to happen automatically.
通常,ETL过程是手动地指定何时更新MQT,而不是让更新自动发生。
The subsequent use-case scenarios sections detail four different cases that highlight the benefits of T-ETL.
随后的用例场景小节详细描述能突出 T-ETL的优点的4 种不同用例。
The data staging module stores the original data and temporary data from all data sources for ETL processing.
数据分级模块存储所有数据源的初始数据和临时数据,以用于ETL处理。
Designing ETL jobs (or data flows) is an important aspect of integrating XML into data warehouse environments.
设计ETL任务(或数据流)是将XML集成到数据仓库环境的重要方面。
This section USES two ETL jobs to illustrate the steps to look up the Teradata data based on the input records.
本节将使用两个ETL作业演示根据输入记录查找teradata数据的步骤。
Unlike ETL and data replication, event publishing does not know where the data is going and how it will be used.
和ETL以及数据复制不同,事件发布并不清楚数据的去向以及如何使用数据。
This section USES a sample ETL job to illustrate the steps to extract data from the Teradata table named Orders.
本节将使用一个示例ETL作业来演示从名称为Orders的teradata表中提取数据的步骤。
A third method is to have the summary tables rebuilt after the ETL process using SQL sum and aggregate functions.
第三种方法是在ETL流程之后使用SQLSUM和汇总函数来重构汇总表。
While this example USES Immediate refresh, deferred refresh MQTs are generally more compatible with ETL activity.
虽然这个例子使用立即(Immediate)刷新,但推迟刷新的MQT通常更适合ETL活动。
They have also released Oozie, a workflow engine for Hadoop, which has become the de-facto ETL standard at Yahoo.
他们还发布了Oozie,一个Hadoop的工作流引擎,这已在雅虎成为事实上的ETL标准。
应用推荐