Start a new topic
Answered

Which Golden ID survives when records are merged ?

Which Golden ID survives when records are merged ?


Best Answer

I see 2 situations where Golden records can be merged:

  • from a Merge or Split action in the UI: The lost golden ID record is the one that is dragged and dropped, for example:
10054 is dragged and dropped on 10105
10054 is dragged and dropped on 10105
-> 10054 is lost
-> 10105 survives
  • from an External Load that updates or adds masters and makes existing golden merge together into a single one: The process takes the Golden ID of the following Master Records sort order:
    • B_CONFIRMATIONSTATUS = CONFIRMED first
    • oldest B_CREDATE
    • smallest B_PUBID, B_SOURCEID
1 Comment

Answer

I see 2 situations where Golden records can be merged:

  • from a Merge or Split action in the UI: The lost golden ID record is the one that is dragged and dropped, for example:
10054 is dragged and dropped on 10105
10054 is dragged and dropped on 10105
-> 10054 is lost
-> 10105 survives
  • from an External Load that updates or adds masters and makes existing golden merge together into a single one: The process takes the Golden ID of the following Master Records sort order:
    • B_CONFIRMATIONSTATUS = CONFIRMED first
    • oldest B_CREDATE
    • smallest B_PUBID, B_SOURCEID
Login to post a comment