Not getting Error on Conversion String to Integer in Informatica

0
votes

My source has string and Target has integer column. Suppose my source data is 'RRRR' . Here it is loading 0 in the target with no errors.. Why informatica is not throwing conversion error. Didn't provided any default value.

1
mysqlinformaticainformatica-powercenter
Like I tried to explain in your previous question (stackoverflow.com/questions/61007451/…) Informatica DOES NOT do any conversion in this case. Hence there is no error in INFORMATICA. It's on your database. - Maciejg

1 Answers

0
votes

Try using an expression to identify if incoming record is integer or string. Donot load if check fails.