Skip navigation
Contact Us
827 Views 4 Replies Latest reply: May 13, 2012 10:15 PM by Jaspreet Banga RSS
prabhu balakrishnan Novice 36 posts since
Jun 1, 2011
Currently Being Moderated

May 12, 2012 5:51 AM

not able to update in tgt

when i am implement scd1. insert logic is working fine but update logic is not working it shows an error in the below. data type & precision is matched in both src & tgt. need help

 

 

Severity    Timestamp    Node    Thread    Message Code    Message

INFO    5/12/2012 6:08:33 PM    node01_darkedition    TRANSF_1_1_1    CMN_1053    UPDTRANS: Send OUTPUT row to EMPTGT1: Control=[None]

UPDTRANS: Send OUTPUT row to EMPTGT1: Rowdata: ( RowType=1(update) Src Rowid=1 Targ Rowid=1

  EMPLOYEE_ID13 (EMPLOYEE_ID:Double:): "100.0000000000000"

  FIRST_NAME13 (FIRST_NAME:Char.20:): "Steve"

  LAST_NAME13 (LAST_NAME:Char.25:): "King"

  EMAIL13 (EMAIL:Char.25:): "SKING"

  PHONE_NUMBER13 (PHONE_NUMBER:Char.20:): "515.123.4567"

  HIRE_DATE13 (HIRE_DATE:Date:): "06/17/1987 00:00:00.000000000"

  JOB_ID13 (JOB_ID:Char.10:): "AD_PRES"

  SALARY13 (SALARY:Double:): "24000.00000000000"

  COMMISSION_PCT13 (COMMISSION_PCT:Double:): "(NULL)"

  MANAGER_ID13 (MANAGER_ID:Double:): "(NULL)"

  DEPARTMENT_ID13 (DEPARTMENT_ID:Double:): "90.00000000000000"

  ROWINSERT3 (ROWINSERT:Date:): "05/12/2012 18:08:33.000000000"

)

More Like This

  • Retrieving data ...

Bookmarked By (0)