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
Stéphane Bongiovanni
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.