title: ETL SQL Server 2008 - How to handle non-matching records?
body: <p>I am fairly new to ETL. I am working on this proc and what it does is it loads birthdates of people. This is loaded from a fact table onto a different table. There is no key to join them by, all the three tables involved. I am going to split the Name field and do match with the split name. This loads the matching ones, but my question is I have to load the non matching ones to a different third table. How do I do that logic? </p>
  
  <pre><code>update FactTableEmp F
         set Bdate = S.Birthdate
  
  from   FactTableEmp
         cross apply dbo.split(Name) as u
         join SourceTableEmp S on u.Fname = s.FirstName and u.LName = S.Lastname  
  
  --Is using the one below going to work using the same way above?
  u.Fnames != S.FirstName
  u.Lname != S.Lastname
  </code></pre>