title: How to split datetime into date and time in informatica
body: <p>I am using Informatica 8.1.1. Source flat file contains one date/time field. I want to load it as two separate columns date and time in target table. 
  I tried TO_DATE function to get the date and time separately.
  But it is giving some errors. </p>
  
  <p>How can I split this date/time into date and time?
  or 
  Can we load a string value from source flat file  into a date value in target table?</p>