SENA0001 Member since 2006 10 posts
Ernst & Youngs
Posted: 1 year ago
Last activity: 1 year 7 months ago

Data Flow For Record Deletion


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
Share this page LinkedIn