title: Hardcode date in Informatica
body: <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>