0 Replies Latest reply on Aug 4, 2020 5:11 PM by user11691341

    How to load Duplicate record in different Table and Unique record in different table in ODI12c

    user11691341

      I have a Source table where we need to do some Join with dimension and get the result

      on the Result set we want to Segregate the Unique record to one table and duplicate record to one table.

       

      How to achive this?

       

      Example

       

      Emp Join with Department

             Join with Location

             Join with Date

       

      and Result we want to Push to Emp Fact (with Unique emp id record)

                                                  Emp Dupl Fact(with duplicate empid record)

       

      This duplicate record can be result of duplicate entry in Department or Location or date or Emp Table