This step also includes ETL process design.
该步骤还包括ETL过程设计。
What are the four basic Data Flow steps of an ETL process?
在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过程中对装载的数据进行的编辑非常少。
An external system (usually a result of an ETL process) deposits UMF files in a slot.
外部系统(通常是ETL过程的结果)将UML文件存放在一个数据槽中。
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过程设计、用户手册,等等。
A third method is to have the summary tables rebuilt after the ETL process using SQL sum and aggregate functions.
第三种方法是在ETL流程之后使用SQLSUM和汇总函数来重构汇总表。
The data repository module stores all integrated business data, it is the final target of data acquisition ETL process.
数据存储库存储所有的集成业务数据,它是数据获取ETL过程的最终目标。
At an interval configured by you, the captured short-term history data will be migrated into the PWH tables using an ETL process.
捕获的短期历史数据以用户配置的时间间隔,通过ETL过程迁移到pwh表中。
A data warehouse is updated on a regular basis by the ETL process (run nightly or weekly) using bulk data modification techniques.
数据仓库定期地通过ETL过程(每个晚上或者每周运行)来更新,ETL过程使用大块的数据更新技术。
The WebSphere DataStage job illustrated in Figure 3 USES a typical ETL process in order to achieve the desired result in a structured fashion.
图3中的WebSphereDataStage作业使用一个典型的ETL过程,以一种结构化的方式获取所需的结果。
Users can also redefine data transform rules by their own needs. In this way, the flexibility and versatility of the ETL process is increased.
用户也可以根据自己的需求重新定义数据转换规则,通过这种方式增加了ETL过程的灵活性。
Solution implementation cycle: the data warehouse implementation includes the target repository and the data mart database, as well as ETL process implementation.
解决方案实现周期(Solution implementation cycle):数据仓库实现包括目标存储库和数据集市数据库,以及ETL过程实现。
As the BOSS system is ORACAL database, which in TERADATA there is no direct interface, so the data need to be addressed, primarily by the ETL process scheduling tool.
由于BOSS系统用的是ORACAL数据库,且于teradata之间没有直接接口,需要对数据进行处理,主要由etl工具实现过程调度。
Stay tuned for the upcoming articles in this series, which will continue to explore warehouse ETL process design and implementation, warehouse performance, security, and more.
继续本系列中的下一篇文章,其中将继续探索仓库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过程中,将时间戳从一个地区转换为另一个地区的函数被证明是转换方面的主力。
In this paper, we focus on two different perspectives to improve ETL tool, a reduce the data set which ETL process deals with, b improve performance of ETL process per time unit.
本文从减少ETL过程处理数据集规模和提高单位时间内etl过程数据处理能力两个角度入手对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过程中,即时参照完整性和检查约束极其有助于检测数据问题,在最终的数据仓库表中实现它们也不会高效。
For ensuring the reliability of data, this paper deals with the golf data which has quality problems together with the ETL process, made the Decision-making analysis based on a unified data view.
针对高球数据的一些质量问题结合ETL过程对数据进行有效的处理,保证了数据的可靠性,使决策分析建立在一个统一的数据视图上。
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代码或重复整个的映射过程。
Another way is to have the extract, transform, and load (ETL) process update the summary table as it loads the fact table.
另一种方法是使提取、转换和加载(etl)流程在加载事实表时更新汇总表。
However, there are some problems at the process of developing ETL system. One of the most typical problems is the confusing management of metadata.
然而,在目前开发etl系统的过程中,存在着一些问题,其中最典型的就是元数据管理混乱的问题。
The entity identification process frame for carrying out the data filtering function of data ETL (data extraction, transformation and loading) is brought forward.
分析了常见实体识别算法,提出了实体识别过程框架,用以实现数据ETL的数据规约功能。
The entity identification process frame for carrying out the data filtering function of data ETL (data extraction, transformation and loading) is brought forward.
分析了常见实体识别算法,提出了实体识别过程框架,用以实现数据ETL的数据规约功能。
应用推荐