Hi
I am inserting teradata table using ODBC stage ( used b'se of performance reasons)
while loading the NULL values it is being replace by junk and empty string.
in the derivation I am doing following
1. the column data typeVarchar and the derivation on the insert transformer is @null -- in database it is getting replaced by empty string
2. another column has source data type as char , while inserting the datatype is varchar.
derivation of the column is ISnull(colname) then @NULL else coluname , all the null values are replace by junk values.
Any thought on where why this is happening. I can't change the ODBC stage to teradataAPI stage.
NULL replace with junk and empty string
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 37
- Joined: Fri Oct 21, 2005 4:09 am
NULL replace with junk and empty string
Thanks and Regards
Abha
Abha
-
- Participant
- Posts: 64
- Joined: Fri Jan 25, 2008 4:41 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
How are you checking the data in TD ? if your using the SQL assistant you can set the options in the SQL assistant on how to display NULL's. i think yours might be set to empty string maybe? Is the data coming through ok as this does not seem to be a problem with the job itself and TD.
Teradata Certified Master V2R5