1 Reply Latest reply on Aug 26, 2018 11:40 PM by EC140656

    High Precision and decimal conversion Error

    Arka De New Member

      I have a mapping with decimal and varchar fields in my source and I am trying to move the data(containing unicode characters) from Teradata to Greenplum.

      For this I am custing only my char/varchar data in SQ Override query to varchar. But I am getting below error for decimal field while TPT read.

      "Conflicting data type for column(14) - Col1. Source column's data type is (VARCHAR) Target column's data type is (DECIMAL)"

      Col1 has datatype decimal(25,3) and it has been defined as decimal(25,3) through out the mapping starting from source to target.

       

      I have enabled High Precision which i require for one of my other field.

      Can anyone help me out of this issue? I am not understanding my Source is treated as Varchar?

        • 1. Re: High Precision and decimal conversion Error
          EC140656 Seasoned Veteran

          Hi,

          Check what is the datatype you have defined for the field in the Source transformation?

           

          Since you have mentioned that you are typecasting the varchar field to decimal in the "Source Qualifier" transformation, the field should be defined as "varchar" only in the Source transformation & Source Qualifier transformation.

           

          If it is defined as "decimal" in the Source transformation, it is likely to give an error while reading data from Teradata as the Teradata send the field as varchar whereas the "Source " transformation in Informatica expects a decimal.

           

          Check it out as I don't know how you have defined it. The datatype defined for the field in the rest of the pipeline is irrelevant as you are typecasting in the "Source Qualifier" transformation to decimal.

           

          The other scenario that I could think of from your description is that you are wrongly linking a "varchar" datatype field to "decimal" datatype field. This could be obvious but nevertheless wanted to mention it here & please check it out.

           

          Regards

          Krishna