How and Where to save a Record ID before deleting it from GD table.
F
Fathia Jama
started a topic
over 2 years ago
How and Where to save a Record ID before deleting it from GD table.
Best Answer
F
Fathia Jama
said
over 2 years ago
Hi Rakesh,
Deleted records are stored in the GX table for Golden records and the MX table for master records. There are also two types of deletes.
When doing a hard delete, this step deletes any trace of the records in every table (SA, SD, UM, MH, GH, etc.). The only trace of a hard delete is the ID (without data) of the deleted master and golden records, in the GX and MX tables. Deletes are tracked in the history for golden and master records (in the MH and GH tables), if historization is configured.
A Soft Delete that logically deletes records by moving them to a deleted records storage. There you can find the record values.
1 Comment
F
Fathia Jama
said
over 2 years ago
Answer
Hi Rakesh,
Deleted records are stored in the GX table for Golden records and the MX table for master records. There are also two types of deletes.
When doing a hard delete, this step deletes any trace of the records in every table (SA, SD, UM, MH, GH, etc.). The only trace of a hard delete is the ID (without data) of the deleted master and golden records, in the GX and MX tables. Deletes are tracked in the history for golden and master records (in the MH and GH tables), if historization is configured.
A Soft Delete that logically deletes records by moving them to a deleted records storage. There you can find the record values.
Fathia Jama
How and Where to save a Record ID before deleting it from GD table.
Hi Rakesh,
Deleted records are stored in the GX table for Golden records and the MX table for master records. There are also two types of deletes.
When doing a hard delete, this step deletes any trace of the records in every table (SA, SD, UM, MH, GH, etc.). The only trace of a hard delete is the ID (without data) of the deleted master and golden records, in the GX and MX tables. Deletes are tracked in the history for golden and master records (in the MH and GH tables), if historization is configured.
A Soft Delete that logically deletes records by moving them to a deleted records storage. There you can find the record values.
Fathia Jama
Hi Rakesh,
Deleted records are stored in the GX table for Golden records and the MX table for master records. There are also two types of deletes.
When doing a hard delete, this step deletes any trace of the records in every table (SA, SD, UM, MH, GH, etc.). The only trace of a hard delete is the ID (without data) of the deleted master and golden records, in the GX and MX tables. Deletes are tracked in the history for golden and master records (in the MH and GH tables), if historization is configured.
A Soft Delete that logically deletes records by moving them to a deleted records storage. There you can find the record values.
-
Can we reset Matches and run again on match rule change or add a new match rule?
-
"Unmerge" records
-
Turn off match rules to speed up an integration job
-
Can anyone tell me how to load a Fuzzy-Matched entity ... but skip the matching happening auto-magically?
-
Importing CSV in Fuzzy Matched Entity Does Not Trigger Consolidation
-
How can I trigger a "match on child records"?
-
How can I Configure Most Frequent Values in Survivorship Rules?
-
Deterministic or probabilistic matching
-
Machine Learning and AI for matching
-
Prevent loads from replacing values overridden by users
See all 43 topics