下面的命令加载数据到目标数据库中。
The following command loads the data into the target database.
每个联邦目标数据库都需要一组控制表。
One set of control tables is needed for each federated target database.
访问目标数据库不需要执行数据整合过程。
Accessing the target database does not require the execution of a data-consolidation process.
把源和目标数据库的数据存储都分配给用户。
Assign both the datastores for your source and target databases to users.
方法1要求目标数据库被配置为联邦数据库。
Approach 1 requires that the target database is configured as federated database.
为目标数据库添加数据存储的步骤是相同的。
Use the same steps as a guide for adding a datastore for your target database.
DDL还可以回滚，但这取决于目标数据库的功能。
Based on the target database capabilities, the DDL can also be rolled back.
其次，无法对目标数据源进行复制来满足访问需求。
Next, the target data sources cannot be replicated or copied in order to fulfill the access requirement.
为简化测试，目标数据仓库数据库也配置为TPoX。
For testing simplicity, the target data warehouse database is also configured to be TPoX.
因此，这种方法的性能特性仅由目标数据库服务器决定。
Therefore, the performance characteristics of this approach are determined only by the target database server.
也就是说，为了成功地执行复制，需要访问目标数据库。
This means in order to perform the replication successfully, the target database needs to be accessed.
容器将用能被目标数据库接受的最低级锁定来装载数据。
The container will load the data with the weakest lock available for the targeted database.
用户名必须与目标数据库中创建表时所在的模式相匹配。
The user name must match the schema name where tables are created in target database.
最后，整合服务器将经过转换的数据应用于目标数据存储。
Last, the consolidation server applies the transformed data to the target data store.
使用XML配置文件为每个目标数据库定义不同的SQL。
Use XML configuration files to define different SQL for each target database.
对于本文中的示例，目标数据库服务器是DB 2UDB。
For the example in this article, the target database server is DB2 UDB.
本节概述在源数据库和目标数据库之间设置复制订阅的步骤。
This section gives an overview of the steps to set up a replication subscription between your source database and a target database.
为了简化测试过程，存储目标数据的数据库也配置为TPOX。
For testing simplicity, the target data warehousing database is also configured to be TPOX.
如果需要修改目标模型，那么目标数据也需要进行相应的调整。
If the target model needs to be modified, the target data will need to be adjusted accordingly.
订阅是在源数据存储和目标数据存储之间复制数据所需的连接。
A subscription is a connection that is required to replicate data between a source datastore and a target datastore.
它还通过向各种目标数据源提供一致的规范来简化程序设计模型。
It also simplifies the programming model by providing consistent specifications to various target data sources.
如果目标数据库是DB2，将已配置的捕获文件绑定到db2包。
Bind the configured capture file into DB2 packages, if the target database is DB2.
下面的表展示了MT K目前支持的源数据库与目标数据库的组合。
The following table shows the source and target database combinations that MTK currently supports.
为获得最佳性能，客户机应用程序需要被路由到存放目标数据的分区。
For optimal performance, the client application needs to be routed to the partition that houses the target data.
DB 2II负责把该查询分解成能被每个目标数据源处理的几块。
DB2 II took care of decomposing this query into pieces that could be processed by each of the target data sources.
LOAD_ONLY：将指定的所有表从源数据库装载到目标数据库中。
LOAD_ONLY: Loads all specified tables from the source database to the target database.
但是，首先应该在目标数据库mysample中创建存储过程。
But first you should create your stored procedure in the destination database MYSAMPLE.
如果目标数据类型与实际数据不兼容，XMLCAST函数会引发错误。
The XMLCAST function can raise errors if the target data type is incompatible with the actual data.
本节描述为源和目标数据库创建数据存储并把它们分配给用户所需的步骤。
This section describes the steps required to create datastores for your source and target databases and assign them to users.
表间关系、主键列和其他有关目标数据的信息也是通过元数据对象指定的。
Inter-table relationships, primary key columns, and other information about the target data is specified through the metadata object as well.
应用推荐