Archives of the TeradataForum

Message Posted: Tue, 21 Aug 2012 @ 14:36:00 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Nice Answer..

Data is already loaded into target table, I want to cross check with my query(Source MINUS Target). In my table I have 4 types of data.

1) invalid date it should be replace with null

2) valid date, we should move date

3) less than 1950 , we should move null

4) greater than today+5 years , we should move null

Thanks

Vinod

	<Prev	Next>		<<First	<Prev	Next>	Last>>