Tag: transformer
Datastage : Schema reconciliation detected a size mismatch in timestamp
by Frederick Tybalt on Jul.31, 2017, under Error and Issues
Error Message:
Schema reconciliation detected a size mismatch for column DT. When writing column DATETIME(fraction=6) into database column DATETIME(fraction=0), truncation, loss of precision, data corruption or padding can occur.
Resolution :
This issue occurs when the source stream is read as times tamp with microseconds and when writing into target the time stamp field does not have microseconds scale. There is no direct functions to truncate the microseconds scale, as a work-around below method can be used.
StringToTimestamp(TimestampToString(from_xfm.DT,"%yyyy-%mm-%dd %hh:%nn:%ss") ,"%yyyy-%mm-%dd %hh:%nn:%ss")