How to compare data from tables in Teradata with tables in Oracle

Database

Re: How to compare data from tables in Teradata with tables in Oracle

How you load the date records from oracle to teradata table without casting into date format.

Teradata Employee

Re: How to compare data from tables in Teradata with tables in Oracle

Hi,

Is it possible for you to look into INMOD option? Or can you load the TIMESTAMP such as "12-07-2011:23:58:23" as VARCHAR(19) and then process using SQL?

Regards, Adeel

Fan

Re: How to compare data from tables in Teradata with tables in Oracle

Krish -

You can load timestamp field to Teradata using fastload only if the data file has the timestamp format "YYYY-MM-DD HH24:MI:SS". Try extracting your data into this format from Oracle. You can set NLS_TIMESTAMP_FORMAT setting in Oracle so it produces the timestamp in this format.