SESSION中的更新策略问题！

中级会员 注册时间: 2008-09-04 07:43:14 文章: 50 离线

下面是我在日志里复制的一些话：
READER_1_1_1> DBG_21438 Reader: Source is [orcl_128], user [testdb]
READER_1_1_1> BLKR_16051 Source database connection [orcl_128] codepage: [MS Windows Simplified Chinese, superset of GB 2312-80, EUC encoding]
READER_1_1_1> BLKR_16003 Initialization completed successfully.
WRITER_1_*_1> WRT_8147 Writer: Target is database [orcl], user [test], bulk mode [OFF]
WRITER_1_*_1> WRT_8221 Target database connection [orcl] codepage: [MS Windows Simplified Chinese, superset of GB 2312-80, EUC encoding]
WRITER_1_*_1> WRT_8124 Target Table EMPLOYEE :SQL INSERT statement:
INSERT INTO EMPLOYEE(EMPLOYEE_ID,NAME,HIRED_DATE,SALARY) VALUES ( ?, ?, ?, ?)
WRITER_1_*_1> WRT_8124 Target Table EMPLOYEE :SQL UPDATE statement:
UPDATE EMPLOYEE SET NAME = ?, HIRED_DATE = ?, SALARY = ? WHERE EMPLOYEE_ID = ?
WRITER_1_*_1> WRT_8124 Target Table EMPLOYEE :SQL DELETE statement:
DELETE FROM EMPLOYEE WHERE EMPLOYEE_ID = ?
WRITER_1_*_1> WRT_8270 Target connection group #1 consists of target(s) [EMPLOYEE]
WRITER_1_*_1> WRT_8003 Writer initialization complete.
READER_1_1_1> BLKR_16007 Reader run started.
WRITER_1_*_1> WRT_8005 Writer run started.
READER_1_1_1> RR_4010 SQ instance [SQ_EMPLOYEE] SQL Query [SELECT EMPLOYEE.EMPLOYEE_ID, EMPLOYEE.FRIST_NAME, EMPLOYEE.LAST_NAME, EMPLOYEE.HIRED_DATE, EMPLOYEE.SALARY FROM EMPLOYEE]
WRITER_1_*_1> WRT_8158
为什么我在session 属性里怎么设置 treat source row as 和在mapping标签下修改目标表策略；怎么修改，在上面日志里都是一样的！
treat source row as 和目标表 target load type 有什么作用！服务器根据他们呢之间的设置，会做那些处理呢！为什么所有的日志里都写一样的话！

你还少加粗一个UPDATE语句
INFA在初始化session时还不知道你的rows是INSERT/UPDATE/DELETE/REJECT
这些只是初始化产生的一些信息而已
和你的什么设置无关
==========================
treat source row as
呵呵这个我没用过直译为把源记录看成一般默认都是insert吧忽略不考虑
==========================
target load type
印象中有insert还有datadriven 不清楚了
这个开发中也可以不管他的
只是在某种情况下他不会自动刷新的你手动改成datadriven 以使你mapping中的UPD组件的设置有效