Edit the DB2 source table stage.
编辑DB 2源表阶段。
The source table must be droppable.
源表必须可删除。
Step 3: Adding the source table to the data flow.
步骤3:将源表添加到数据流。
Click add table to add a source table to the query.
单击addTable向查询添加一个源表格。
In the example, the source table is defined as follows.
在这个示例中,源表的定义如下。
If this is a new schedule, the Data Source table will be empty.
如果这是个新的进度表,那么Datasource表将会是空的。
Internally, ADMIN_MOVE_TABLE creates a copy of the source table.
从内部来讲,ADMIN_MOVE_TABLE创建了源表的一个副本。
The source table is protected, and the target table is unprotected.
源表受保护,目标表不受保护。
The target table is protected, and the source table is unprotected.
目标表受保护,源表不受保护。
Changes are tracked through triggers that are created on the source table.
更改是通过在源表中创建的触发器完成跟踪的。
Sometimes, a row in the source table does not have valid coordinate values.
有时候,源表中的一行不具有有效的坐标值。
If the source table is large, this may cause an overflow of the logical log.
如果源表很大,那么这可能导致逻辑日志的溢出。
LBAC read access rules are enforced while reading from source table, however.
然而,在从源表读取数据期间,LBAC读取访问规则被执行。
The column map replicates columns from the source table in the destination table.
列映射会从定义表中的源表格中复制列。
Refresh (Snapshot) replicates a snapshot of the source table to the target table.
Refresh (Snapshot) 把源表的快照复制到目标表。
On the Source Tables page, select the source table that you want to replicate from.
在Source Tables页面上,选择需要进行复制的源表。
ADMIN_MOVE_TABLE moves triggers and views defined on the source table to the target table.
ADMIN_MOVE_TABLE将源表中定义的触发器和视图移动到目标表。
The point table (wells_pts) has a foreign-key relationship with the source table (wells).
点表(wells_pts)和源表(wells)之间有外键关系。
As mentioned above, you must assume that the source table contains latitude and longitude values.
正如上面提到的,必须假设源表包含纬度和经度值。
The source table is either dropped or kept based on one of the ADMIN_MOVE_TABLE input parameters.
根据ADMIN_MOVE_TABLE输入参数之一,源表将被删除或保留。
Use the source changes controls if you want to replicate a subset of the source table columns or rows.
如果需要复制源表中列或行的子集,就使用Sourcechanges控件。
Columns Address and CityStateZip are shown as examples of additional attribute columns in the source table.
Address和citystatezip列作为源表中其他属性列的示例。
If the target table is a multidimensional clustering (MDC) table, the source table must also be an MDC table.
如果目标表是多维集群化(Multidimensional Clustering,mdc)表,则源表也必须是mdc表。
You can specify that the rows are applied by the owner of the source table by using the — applyasowner (-o) option.
也可以通过使用——applyasowner (- o)选项,规定由源表的所有者来应用那些行。
The bulk copy used to initialize the table, however, processes all rows from the source table in a single transaction.
但是,用来对表进行初始化的批量复制在一个事务中处理来自源表的所有行。
DDL_AND_LOAD: Creates all supported objects from the source schema, and populates the tables with the source table data.
DDL_AND _ LOAD:从源模式创建支持的所有对象,并用源表数据填充表。
Uniqueness in the CCD table must be enforced — either by a primary key or unique index on the source table or CCD table.
ccd表中必须有惟一性约束——可以通过主键或者源表或ccd表上的惟一索引实现。
CCD tables expose data with an associated tracking mechanism to accurately portray a transactional history of the source table.
ccd表通过关联的跟踪机制暴露数据,以便准确地描绘源表的事务历史。
Sybase: If the source table has a column data type of LONG VARCHAR, the nickname is created with a data type of VARCHAR (32672).
Sybase:如果源表具有数据类型为LONGVARCHAR的列,就要用数据类型VARCHAR(32672)创建别名。
With the DECLARE cursor command, a cursor is defined that reads all data of the source table SALES using a trivial SELECT statement.
使用DECLARECURSOR命令定义一个游标,它使用select语句读取源表sales的所有数据。
应用推荐