Question

1
Replies
409
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.