Hi, Does informatica convert string with character to decimal as well as to integer? Is value '5%0.08%' convert to decimal? We may think it wont convert. But its wrong. Here informatica 9.5.1 converts to the value decimal and the output is 5.000000000000000 As same as string to integer value conversion, to_integer('5a.08%') is converted into 5 and to_integer('a5a.08%') is converted into 0. Without fail the mapping, its simply converts and load.