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.
Just set the fractional part of the DECIMAL values to 0. Then these numbers don't have any fractional digits, only the integer part. Something like a DECIMAL(5,0) for a postal code, for example.