How to capture Data Truncation as an Error in informatica
<p>i want  to make my session  fail when ever encountered data Truncation.</p>

<p>current scenario in my  session i am using Teradata TPT script to load data from source to target.</p>

<p>sometime due to datalength mismatch data truncate getting load to target without throwing the error.</p>

<p>EX : souce is VARCHAR(15) and target VARCHAR(10) in this scenario my session is throwing warning only and internally it  trim and truncate rest 5 character. and first 10 char load in to target.i want to  make my session to fail if any truncation occur.</p>

<p>as of now through googling i tried two otpion</p>

<p>1) Reject Truncated/Overflowed rows i checked in this  target proerty</p>

<p>2) Stop on errors  i did set to 1</p>

<p>but still it doesn't solve the probllem.please suggest any other way make it achieve.</p>