Question

1
Replies
384
Views
Close popover
Aishik Sen (SENA0001)
Ernst & Youngs
Aishik Sen
Ernst & Youngs
IN
SENA0001 Member since 2006 11 posts
Ernst & Youngs
Posted: January 28, 2019
Last activity: January 28, 2019
Closed

Data Flow For Record Deletion

Hi,

We have a requirement to archive the Interaction History table (PR_DATA_IH_FACT) based on a condition on date. Interaction records older than a particular date will be sent to an archive table and delete the records from the active Interaction History table.

Considering the volume of records in the table, we are considering a DataFlow based approach for the same.

While we can send the records to an archive table using a DataFlow, can we use the same to delete records from the main IH table? If yes, how?

Also, please let me know if you have any other suggestion/approach to achieve the above requirement.

Pega Customer Decision Hub Data Integration Decision Management
Moderation Team has archived post