为啥这个语句load进去会有删除的行呢?
load client from /d1_data3/sccrm/cdr/load/out_bak/20100907/GSMS.2010090702.20100906.out.2 of del modified by coldel= NOROWWARNING
S timestampformat="YYYYMMDDHHMMSS" dateformat="YYYYMMDD" insert into DW_NEWBUSI_SMSCDR_20100906
Summary of Partitioning Agents:
Rows Read = 111684
Rows Rejected = 0
Rows Partitioned = 111684
Summary of LOAD Agents:
Number of rows read = 111684
Number of rows skipped = 0
Number of rows loaded = 111684
Number of rows rejected = 0
Number of rows deleted = 740
Number of rows committed = 111684
请大家帮我看看呢?
收起