How and Where to save a Record ID before deleting it from GD table. : Portal

Start a new topic

Answered

How and Where to save a Record ID before deleting it from GD table.

Fathia Jama

started a topic almost 3 years ago

How and Where to save a Record ID before deleting it from GD table.

Best Answer

Fathia Jama said almost 3 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

Fathia Jama

said almost 3 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.

A Soft Delete that logically deletes records by moving them to a deleted records storage. There you can find the record values.