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.
正如上面提到的,必须假设源表包含纬度和经度值。
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表。
The bulk copy used to initialize the table, however, processes all rows from the source table in a single transaction.
但是,用来对表进行初始化的批量复制在一个事务中处理来自源表的所有行。
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语句)。
The source table must be a nonpartitioned table or a partitioned table that has only one partition and no attached or detached partitions.
源表必须是非分区表,或者是只拥有一个分区且没有已附加或已分离的分区的分区表。
If the target table is distributed across database partitions, the source table must also be distributed using the same distribution method.
如果目标表跨多个数据库分区分布,则源表也必须使用相同的分布方法分布。
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
当更新源表中的坐标列时,必须构造一个新的点几何值。
Figure 2 summarizes this for the example I use for the code samples throughout this article, assuming a source table that represents well locations.
图2总结了本文中代码示例所使用的表结构,假设源表代表水井的位置。
This means that every row in the point table must have a key value (consisting, in this case, of two column values) that must also exist in the source table.
这意味着点表中每一行的键值(在这个示例中,由两个列值组成)必须也在源表中存在。
The sample scenario in this article stores operational XML data in the TPOXADMIN.ACCOUNT table, which serves as the source table to DataStage for this scenario.
本文的样例场景将XML运营数据储存在 TPOXADMIN.ACCOUNT表中,该表充当DataStage 的源表。
A user-copy table can have the same structure as the source table or it can have a subset of source columns, with or without before images or calculated columns.
User - copy表拥有的结构可以与源表相同,也可以拥有源列的子集,带有或不带有前映像(before image)或计算列。
This article, the first in a two-part series, illustrated how to build a single data flow that uses an XML-based source table to populate two target data warehouse tables.
本文是一个分两部分的系列的第一篇文章,文中阐述了如何构建一个数据流,该数据流使用一个基于 XML 的源表填充两个目标数据仓库表。
Conceptually, the merge function joins source table rows with target table rows by applying the on clause filter. All the joined rows are updated or deleted on the target.
从概念上说,merge函数通过应用on子句过滤,将源表行与目标表行进行联接,所有联接的行都在目标中进行更新或者删除。
This data flow simply reads the XML data from the source table and uses a single XML Relational Mapping operator to populate the target table directly, as shown in Figure 2.
这个数据流从源表中读取XML 数据,然后使用一个 XMLRelationalMapping操作符直接填充目标表,见图 2。
Therefore, if your source table was either a parent or child in an RI relationship, you need to capture the foreign keys definition and recreate them after the table is moved.
因此,如果源表在RI关系中为父表或子表,您需要捕捉外键定义并在移动表之后重新创建它们。
It is easier to describe this in detail using the explain output shown in Listing 7. Sequential scan is done on the source table, and index look-up is done on the target table.
可以很方便地利用清单7中展示的explain输出来描述其细节,可以对源表进行顺序扫描,并且在目标表上完成索引查找。
The spatial table has a simple structure: a unique, integer column (objectid), one or more columns making up the primary key (copied from the source table), plus a single point-geometry column.
空间表的结构很简单:一个惟一的整数列(objectid),组成主键的一个或多个列(从源表复制的),以及一个点几何列。
The change tables used by change data capture contain columns that mirror the column structure of a tracked source table, along with the metadata needed to understand the changes that have occurred.
在CDC使用的变更数据表中,包含了被跟踪源数据表的列结构的镜像列,并额外包含了一些元数据来记录发生了那些变更。
应用推荐