Archives of the TeradataForum
Message Posted: Tue, 27 Mar 2007 @ 20:13:01 GMT
I am pulling data from DB2 to Teradata using TPT.
TPT is doing Fastload.
I am getting an error when Column2 contains NULL Values with SourceCoulmn Data type as DATE. It is working fine when it doesn't encounter any Null Values.
DB2 Source Structure: Column1 CHARACTER (10), Column2 INTDATE
Teradata Structure E.g.:
CREATE SET TABLE ABC ( Column3 VARCHAR (10), Column4 DATE FORMAT 'YYYY-MM-DD' ) PRIMARY INDEX (Column1);
Fastload does this Insert Statement:
'INSERT INTO ABC (Column3, Column4) VALUES (:Column1, :Column2);'
Please advise the general process to load data in to Teradata using FastLoad when the Source Date Field contains NULL values.
Currently I made it to work using Coalesce (Column2,'defaultdate') but I need to go back and update them as null.
Another way that I am trying is to make Column4 as Column4 CHAR (10) in Teradata and when inserting, I am trying to transform Column2 to CHAR-- - VALUES (:Column1, :Column2 Char(10)). Could some one correct the Transformation.
Thanks in advance for your suggestions
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|