Expand my Community achievements bar.

SOLVED

NmsAddress Clean up

Avatar

Level 4

I would like to know on what scenario records will be deleted from the address table. I see that records are being deleted from this table but dont know on what reasons it deletes.

1 Accepted Solution

Avatar

Correct answer by
Level 8

Hi

In NmsAddress schema, usually the blacklisted,quarantine, valid, whitelisted data will be available.

The valid address will be automatically removed from this table using the option NPAI (NmsCleanup_LastCleanup) which is a part of clean up process.

This task lets you delete records which matches valid addresses from the NmsAddress table.

Check below link for the query how it will process

Database cleanup workflow

View solution in original post

3 Replies

Avatar

Level 6

Hi,

they might be purged based on purge settings. check here for further details

Purging events

Avatar

Correct answer by
Level 8

Hi

In NmsAddress schema, usually the blacklisted,quarantine, valid, whitelisted data will be available.

The valid address will be automatically removed from this table using the option NPAI (NmsCleanup_LastCleanup) which is a part of clean up process.

This task lets you delete records which matches valid addresses from the NmsAddress table.

Check below link for the query how it will process

Database cleanup workflow

Avatar

Level 4

I Oversight this page. Thanks for your help