Start a new topic
Discussions xDM xDM - Integration
Answered

XDM - How to retreive Golden History after consolidaiton/merge/split

In the xDM, the end user would like to be able with SQL a golden history after consolidation/merge/split.

For exemple, we have a golden uuid at time T.

But after some integration or merge or split, the golden does'nt exist in GD. The end user would like to retreive from the golden uid the new golden uuid even if there are many consolidation split or merge.

Best Answer

Hello

In case one of the goldenID is dropped (during a merge ), there isn't many ways to find its data.
The best way to do so is to get it from the MH_ table, but that requires you to have master historization enable.
To get every goldenID that was liked or merge into a specific goldenID, you can use the following query 

select distinct MH.ID
from MH
join MD
on MD.SourceID = MH.SourceID and MD.PubID = MH.MH.PubID
where MD.ID = <GoldenID>

 Then you can query your GH_ table based on these IDs to get your history

1 Comment
Answer

Hello

In case one of the goldenID is dropped (during a merge ), there isn't many ways to find its data.
The best way to do so is to get it from the MH_ table, but that requires you to have master historization enable.
To get every goldenID that was liked or merge into a specific goldenID, you can use the following query 

select distinct MH.ID
from MH
join MD
on MD.SourceID = MH.SourceID and MD.PubID = MH.MH.PubID
where MD.ID = <GoldenID>

 Then you can query your GH_ table based on these IDs to get your history

Login to post a comment
More topics in xDM - Integration
See all 61 topics
Help Desk Software by Freshdesk