Add the source table or tables to the Diagram pane.
将一个或多个源表添加到“关系图”窗格中。
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.
有时候,源表中的一行不具有有效的坐标值。
Refresh (Snapshot) replicates a snapshot of the source table to the target table.
Refresh (Snapshot) 把源表的快照复制到目标表。
ADMIN_MOVE_TABLE moves triggers and views defined on the source table to the target table.
ADMIN_MOVE_TABLE将源表中定义的触发器和视图移动到目标表。
As mentioned above, you must assume that the source table contains latitude and longitude values.
正如上面提到的,必须假设源表包含纬度和经度值。
Select a query from the drop-down list of available queries for the selected data source 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.
但是,用来对表进行初始化的批量复制在一个事务中处理来自源表的所有行。
If you do not specify a search condition, all rows from the source table will be copied to the destination table.
如果未指定搜索条件,则将源表中的所有行都复制到目标表中。
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的所有数据。
After copying all rows in table SALES successfully to table SALES_TMP, the source table SALES can be dropped (drop table statement).
在把sales表中的所有行成功地复制到SALES _ tmp表之后,可以删除源表(DROPtable语句)。
By replicating a critical source table to a CCD target table, it is possible to rebuild the table from scratch, transaction by transaction.
通过将关键的源表复制到一个CCD目标表,就可以逐个事务地从头开始重建这个表。
If the target table is distributed across database partitions, the source table must also be distributed using the same distribution method.
如果目标表跨多个数据库分区分布,则源表也必须使用相同的分布方法分布。
The source table name is required. }One or more of the source table name fields are blank. A table name is required for importing data.
{需要源表名称。}一个或多个源表名称域为空。导入数据需要表名称。
The source table must be a nonpartitioned table or a partitioned table that has only one partition and no attached or detached partitions.
源表必须是非分区表,或者是只拥有一个分区且没有已附加或已分离的分区的分区表。
The Data Source table in the Resource Monitoring tab displays the configured data sources that are collected from when this schedule executes.
ResourceMonitoring选项卡中的DataSource表展示了,当执行该进度表时,收集的数据所来自的配置的数据源。
While the table is being moved, the ADMIN_MOVE_TABLE routine also creates a staging table that keeps track of all changes to the source table.
尽管已经移动了表,ADMIN_MOVE_TABLE例程还会创建一个阶段(staging)表,该表将跟踪源表中发生的所有更改。
If a row has already been updated or deleted, then this row cannot be joined again with any source table row for another update or delete again.
如果一个行已被更新或者删除,那么不能针对该行再次更新与删除,再次与任何源表联接。
There is another row in the source table with a value of 10 for the customer_num column, which joins with the same row in the target table.
还有其他行中列customer_num的值为10,其与目标表中的相同行联接。
For example, if a duplicate source table row matches exactly with the same target table row that has been updated, you will see the error message.
例如,如果复制已被更新的、与相同目标表行匹配的源表行,那么您将会看到错误消息。
End-to-end latency is the time it takes from the point in time when an update occurs at a source table until that update is applied to the target.
端到端延时是指从源表发生更新到此更新应用到目标表所经历的时间。
When either of the coordinate columns in the source table is updated, a new point geometry must be constructed. The update trigger looks like this
当更新源表中的坐标列时,必须构造一个新的点几何值。
应用推荐