6 Replies Latest reply: Aug 7, 2013 7:10 AM by John Ophof RSS

    Loading data exists

    John Ophof

      I have two tables one with training records having a field called employee ID. Another table holds the employee data with employeeID employee name and organization code.

      I have 55000 records where there is no employee found in the employee table.

      This data is loaded completely now creating unnecessary large files. How can I load only those training records where there is a hit in the employee table?

      Something in the from clause?

       

      Thanks

      John