Informatica giving error while loading Teradata Number column -
in teradata(13.5) target table have column data-type number; when try load table using informatica flow gives following error:
[severity timestamp node thread message code message error 4/1/2015 3:08:52 pm node01_<host_name> writer_1_*_1 wrt_8229 database errors occurred: fnname: execute -- [teradata][odbc teradata driver] illegal data conversion]
we have tried including:
1. changing informatica target datatype decimal, bigint, integer, varchar
2. importing target table informatica using informatica target designer number field imported varchar(0)
please suggest how solve changing target data-type not option us.
you can import target table informatica using informatica target designer, , edit datatype column want. can alterered without issues.
Comments
Post a Comment