title: Informatica giving error while loading Teradata Number column
body: <p>In a Teradata(13.5) target table we have column with data-type Number; when we try to load this table using Informatica flow it gives following error: <br></p>
  
  <pre><code>[Severity Timestamp Node Thread Message Code  Message
  ERROR  4/1/2015 3:08:52 PM node01_&lt;host_name&gt;     WRITER_1_*_1 WRT_8229 Database errors occurred: 
  FnName: Execute -- [Teradata][ODBC Teradata Driver] Illegal data conversion]
  </code></pre>
  
  <p>We have tried everything including: <br>
  1. Changing Informatica target datatype to decimal, bigint, integer, varchar<br>
  2. Importing target table to Informatica using Informatica Target Designer but this Number field is imported as Varchar(0)<br>
  Please suggest how to solve this as changing target data-type is not an option for us.</p>