7 Replies Latest reply on Feb 13, 2020 12:18 PM by Nico Heinze

    To capture records which do not meet the join condition in the same target

    inuser511275 New Member

      How do i capture records which do not meet the join condition in the same target?

      Source 1

      10 XXX

      20 YYY

       

      Source 2

      10 XXX

      20 ZZZ

      30 TTT

       

      Target:

       

      10 XXX

      20 YYY

      30 TTT

       

      I used a full outer join and do i need to flag rows based on null values?

       

      My sources are Flat files.

       

      Please suggest