ITPub博客

首页 > Linux操作系统 > Linux操作系统 > applied and affected rows

applied and affected rows

原创 Linux操作系统 作者:ashleywzl 时间:2011-07-26 17:45:58 0 删除 编辑

Applied Rows  For sources, shows the number of rows the Integration Service successfully read from the source. For targets, shows the number of rows the Integration Service successfully applied to the target.
Note: The number of applied rows equals the number of affected rows for sources. 

Affected Rows  For sources, shows the number of rows the Integration Service successfully read from the source.
For targets, shows the number of rows affected by the specified operation.For example, you have a table with one column called SALES_ID and five rows containing the values 1, 2, 3, 2, and 2. You mark rows for update where SALES_ID is 2. The writer affects three rows, even though there was only one update request. Or, if you mark rows for update where SALES_ID is 4, the writer affects 0 rows.
Note: The number of applied rows equals the number of affected rows for sources. 

source而言,applied and affected rows是相等的.对于target,applied rows是指从source读取数据条数后,插入,应用到target的条数;而affected rows,是指影响的数据库内的,如ID,update

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25676270/viewspace-703158/,如需转载,请注明出处,否则将追究法律责任。

下一篇: sql
请登录后发表评论 登录
全部评论

注册时间:2011-04-11

  • 博文量
    65
  • 访问量
    55118