4 Replies Latest reply on Jul 21, 2021 8:14 PM by Sathiesh M

    How  will Trust Survivorship work

    Rahul Yadav Guru

      Assume scenario below. We would like to downgrade trust of record if Valid Indicator is N. If on Day 2 we get new record with Valid indicator Y, what will happen to golden record.

       

      Day 1

      BO (Before Merge)

      ROWID_OBJECT
      First Name
      Last Name
      Valid Ind
      100Tom (Trust 80)Tim (Trust 80)
      101Tommy (Trust 90)Tim1 (Trust 90)

      N

       

      XREF (Before Merge)

      SRC
      ROWID_OBJECT
      First Name
      Last Name
      Valid Ind
      ABC100Tom (Trust 80)Tim (Trust 80)
      PQR101Tommy (Trust 90)Tim1 (Trust 90)N (Trust 70)

       

      BO After Merge

      ROWID_OBJECT
      First Name
      Last Name
      Valid Ind
      100TommyTimN

       

       

      Day 2

      XREF (After Merge)

      SRC
      ROWID_OBJECT
      First Name
      Last Name
      Valid Ind
      ABC100Tom (Trust 80)Tim (Trust 80)
      PQR100Tommy (Trust 90)Tim1 (Trust 90)N (Trust 70)
      ABC100Tom (Trust 80)Cook (Trust 80)Y

       

      What will happen to BO record after day 2?