column varchar(80) to column varchar(40)

General
Enthusiast

column varchar(80) to column varchar(40)

hi every one,

i have column from source as datatype varchar(80) but column in teradata staging table is defined as varchar(40) ...data is truncating and loaded in to staging  table i.e first  40 characters are loading and remaining trunctaing ..is there any way to fail my tpt if the source is more than 40 .

thanks,

mighty