Hi ,
I have a look up stage in which i perform look up based on a key filed and retrieve a date field. But when i dont have a match, the retrieved date field is expeted to be NULL. But in my case , a junk value is coming in this date field '0001-0-01'. The date field which is coming from the look up is made Nullable, but still same problem exists.
Are you saying datastage is defaulting the null to that 0001-0-01?
Is that how it exists in your lookup source?? if its consistently giving you a value like 0001-0-01 can you not use a transformer to convert that into a default value which is more acceptable?
I am getting the junk value 0001-01-01 as date value when there is no match in look up.SO anyway it is not cominf from the look up table. But we cannot tell that in all such cases i will be getting 0001-01-01 as the default value when no look up match.
in fact what exactly the look up doing is , comparing the source data with the target table. So in a case where no records are present in the target table, then i got this type of error.