1 Reply Latest reply on May 22, 2020 9:11 AM by Nico Heinze

    Question regarding Decimal data type in source and target

    Suresh Rangadhamaiah New Member

      Dear All,

       

      There is a small issue which is bothering me. I have found that when in the database , the values are numeric without any decimal,  I find that Informatica cloud designer assigns default of DECIMAL datatype to the same field. Due to this even something like postcode is transformed as 2340.00000. So specifically what i want to know , is there a setting where we can define NUMBER as the default datatype.

      Currently to overcome this problem i am using to_integer, but it is cumbersome when you have too many fields.Any help on this would be highly appreciated.

       

      Regards