I am using TPT to load my table.
I am facing an error in converting varchar to TimeStamp(0).
The segment code which is giving the error is :
STEP LOAD_DATA_INTO_TABLE ( APPLY ('INSERT INTO '||@TargetTable||'( :IDNT_TICK, :MSG_ID, :MSG_ID2, :MSG_ID_SERV, :SPLIT_ROW_NUM, :COMP_REIN_NUMR_FACT, :NUMR_FACT );') TO OPERATOR (LOAD_OPERATOR ) SELECT * FROM OPERATOR ( FILE_READER  ); ); );
IDNT_TICK is the column of data type Timestamp(0) which is defined as varchar(14) in the TPT.
Kindly let me know if there are any fixes.
Sample data would help .... but it seems to be a FORMAT issue.
The timestamp(0) is expected to have length 20 by teradata. Hence the issue must be with source data or the defintion that has got length of 14 resulting in truncation.