Hi,
My Source table is CEM_DB and target_table is TARG_DB. Now below is the list of columns as shown below
CEM_DB
=====================================================
CEM_ID INTEGER,
LATEST_UPDATE_TIMESTAMP TIMESTAMP(6),
TRANS_TIME TIMESTAMP WITH TIME ZONE,
RR_TIME TIMESTAMP WITH TIMEZONE
CT_TIME TIMESTAMP(6)
TARG_DB
=========================================
TARG_ID INTEGER,
TARG_NAME VARCHAR2(30),
LATEST_UPDATE_TIMESTAMP TIMESTAMP(6),
TRANS_TIME TIMESTAMP WITH TIME ZONE,
RR_TIME TIMESTAMP WITH TIMEZONE,
CT_TIME TIMESTAMP(6),
INSERT_DATE DATE
Now this is the Mapping of each column
CEM_ID maps to targ_id column,
TARG_NAME SHOULD BE NULL,
LATEST_UPDATE_TIMESTAMP of CEM_DB maps to LATEST_UPDATE_TIMESTAMP of TARG_DB
TRANS_TIME of CEM_DB maps to TRANS_TIME OF TARG_DB
RR_TIME of CEM_DB maps to RR_TIME of TARG_DB
CT_TIME of CEM_DB maps to TRANS_TIME of TARG_DB
LATEST_UPDATE_TIMESTAMP of CEM_DB maps to INSERT_DATE.
Now the problem here is the LATEST_UPDATE_TIMESTAMP of CEM_DB is a timestamp(6) datatype whereas INSERT_DATE Column is datetype. I need to insert the records from CEM_DB to TARG_DB as they 1:1 data.
While loading this from Oracle I am getting Year OUT of Range Error.
Tried following.
· Loaded month wise data and it loaded successfully.
· When loading bulk data it fails.
· Tried distinct length(update_time_stamp) from event_table. Giving 26
· Tried distinct extract(year from update_time_stamp) from event_table. – giving correct value
· Tried distinct extract(day from update_time_stamp) from event_table. giving correct value
Source and target table structure is same. It is timestamp(6) at both side.
Appreciatie your help on this to resolve the above error which is YEAR OUT OF RANGE ?
Regards,
Thakur Manoj R