Date Column in Lookup stage
Posted: Mon Apr 20, 2009 3:03 am
Hi
I am using Teradata stage as reference data for a Lookup stage. After key lookup between primary and referece stage, column extracted is DATE datatype.
Problem
--------
If lookup fails then, output DATE column is populating default date as "0001-01-01"
Is that how the stage behaves for date columns ?
How to populate NULL values
ETHAN
I am using Teradata stage as reference data for a Lookup stage. After key lookup between primary and referece stage, column extracted is DATE datatype.
Problem
--------
If lookup fails then, output DATE column is populating default date as "0001-01-01"
Is that how the stage behaves for date columns ?
How to populate NULL values
ETHAN