Hardcode date in Informatica
<p>Have a question on Informatica powercenter. We have a target column END_DATE in oracle as date which is populated from a different column. I put an expression transformation and used an IF condition.</p>

<p>IIF(Status='Expired',Currentdate,'12/31/9999')</p>

<p>Basically, if status column has a value 'Expired' it will update END_DATE column as current date ELSE it will put an infinite date such as '12/31/9999'.</p>

<p>Thanks for your help.</p>