When I manually merge 2 records, the GH_table shows only the post merge record. Where do I view the old records?
Best Answer
F
Fathia Jama
said
over 2 years ago
When you have Historization enabled, this is not what you should be seeing. No records are lost from the GH table. When two golden records are merged, the one with the 'losing' ID remains in the table.
What you should see against this row is the B_TOBATCHID column now has a value. It's like a history record, not with an 'end date' but with a 'To Batch'. The 'From Batch' to 'To Batch' indicate between which Integration Batches that record existed as its own golden id.
Try ordering the GH table by the id column and you'll see that it is still there.
1 Comment
F
Fathia Jama
said
over 2 years ago
Answer
When you have Historization enabled, this is not what you should be seeing. No records are lost from the GH table. When two golden records are merged, the one with the 'losing' ID remains in the table.
What you should see against this row is the B_TOBATCHID column now has a value. It's like a history record, not with an 'end date' but with a 'To Batch'. The 'From Batch' to 'To Batch' indicate between which Integration Batches that record existed as its own golden id.
Try ordering the GH table by the id column and you'll see that it is still there.
Fathia Jama
When I manually merge 2 records, the GH_table shows only the post merge record. Where do I view the old records?
When you have Historization enabled, this is not what you should be seeing. No records are lost from the GH table. When two golden records are merged, the one with the 'losing' ID remains in the table.
What you should see against this row is the B_TOBATCHID column now has a value. It's like a history record, not with an 'end date' but with a 'To Batch'. The 'From Batch' to 'To Batch' indicate between which Integration Batches that record existed as its own golden id.
Try ordering the GH table by the id column and you'll see that it is still there.
Fathia Jama
When you have Historization enabled, this is not what you should be seeing. No records are lost from the GH table. When two golden records are merged, the one with the 'losing' ID remains in the table.
What you should see against this row is the B_TOBATCHID column now has a value. It's like a history record, not with an 'end date' but with a 'To Batch'. The 'From Batch' to 'To Batch' indicate between which Integration Batches that record existed as its own golden id.
Try ordering the GH table by the id column and you'll see that it is still there.
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 263 topics