The federated optimizer also allows the T-ETL solution to be adaptive, as the best join strategy and link ordering may change as the characteristics of the data in the job change.
联邦优化器还使t - ETL解决方案更具有可适应性,因为当作业中数据特征发生变化时,最佳连接策略和链接顺序也可能随之变化。
Almost any data consolidation scenario with tasks (such as joins, merges, filtering, and aggregations) that can reduce input data early in the data flow can benefit from T-ETL processing.
凡是具有能在数据流早期减少输入数据的作业(例如连接、合并、过滤和聚合)的数据整合场景,几乎都能从t - ETL处理中受益。
The T-ETL job shown in Figure 4 executed in just 127 seconds -- an overall elapsed time improvement of 38 percent.
而图4 中显示的 T-ETL 作业的执行时间只有 127秒 —— 总体执行时间缩短了 38% 之多。
The SQL within the T-ETL job refers to pre-defined nicknames that exist within the federated database, rather than the actual source tables themselves.
T-ETL 作业中的SQL引用联邦数据库中预定义的昵称,而不是实际的源表。
The subsequent use-case scenarios sections detail four different cases that highlight the benefits of T-ETL.
随后的用例场景小节详细描述能突出 T-ETL的优点的4 种不同用例。
The four use cases described above are all typical data consolidation scenarios that benefit from employing a T-ETL approach to move and transform data.
前面描述的4个用例都是能从采用T - ETL方法移动和转换数据中受益的典型数据整合场景。
The following section of this article provides a brief introduction to WebSphere Federation Server before describing the T-ETL architecture in more detail.
在更详细地描述T-ETL架构之前,本文接下来的小节将简要地对WebSphereFederationServer 作一个介绍。
The T-ETL version of the job that USES WebSphere Federation Server as a data pre-processor executes in just 12 mins 11 secs (731 seconds), an elapsed time saving of approximately 83 percent.
而使用WebSphereFederationServer作为数据预处理器的t -ETL版本的作业则仅执行了12分11秒(731秒),执行时间节省了大约83%。
Identify jobs that will benefit from t-etl.
识别可从t -ETL中获益的作业。
The original StockCheck WebSphere DataStage job executed in 682 seconds, while the T-ETL version of the job executed in 124 seconds; an approximate elapsed time improvement of 82 percent.
原始stockcheckWebSphereDataStage作业执行时间为682秒,而t - ETL版本的作业的执行时间为124秒。消耗的时间大约缩短了82%。
However, it is a relatively simple task to convert StockCheck into a T-ETL schema by only converting a small part of the job; that is, the join between LINEITEM and STOCK.
但是,将StockCheck转换成t - ETL模式则相当简单,只需转换作业中的一小部分,即LINEITEM与STOCK之间的连接。
However, it is a relatively simple task to convert StockCheck into a T-ETL schema by only converting a small part of the job; that is, the join between LINEITEM and STOCK.
但是,将StockCheck转换成t - ETL模式则相当简单,只需转换作业中的一小部分,即LINEITEM与STOCK之间的连接。
应用推荐