title: ERROR HANDLING and Loading into target Table using SQL
body: <p>I have a scenario Today where I am stucked Up little bit. I have data like this below in my Source Oracle Source Table(Sample Data)</p>
  
  <pre><code>ID,NAME,SALARY,BIRTHDAY
  1,ABHIJIT,2000,17/12/1990
  2,ROHIT,-2000,13/11/1988
  3,MOHIT,500,2075-575-43
  </code></pre>
  
  <p>Now Salary in the 2nd Row is negetive and BIRTHDAY in the 3rd Row is an Invalid Format(Valid is MM/dd/yyyy). Both 2nd and 3rd Row should go to INVALID_EMPLOYEE and 1st record should go to VALID_EMPLOYEE. In the Source File Date Format is coming as dd/mm/yyyy. Which I have to convert to MM/dd/yyyy format and also have to check whether Date Format incoming in Source File is dd/mm/yyyy or not. Salary should not be less than 0. Source Table All columns are in String and in Target Table ID is Integer,NAME as VARCHAR2(255), SALARY is NUMBER and BIRTHDAY is DATE. 
  I have handled all this in my Project ETL Tool. So I am trying to push all this in Query to improve performance.Any help is much appreciated</p>