Question
Accenture
AU
Last activity: 7 Aug 2023 10:33 EDT
Identify Differential Data - Interaction History - Pega Upgrade
Hi,
We are performing a Pega Marketing upgrade from 7.3.0 to Pega 8.6. The plan is as below
- DB Clone Day - 15 days prior to Go-Live, clone existing SQLServer Database (DB1) in Production to DB2.
- Upgrade DB2 to Pega 8.6
- Go-Live day, identify the differential data (difference between DB Clone day and Go-Live date) present in interaction history present in DB1 and DB2 and migrate them to DB2.
Can someone please guide me to the correct strategy to be used in this scenario? I have thought of below steps:
I had thought of the below strategy for the pr_data_ih_fact table.
- Identify records that have been created after DB clone start time.
- Create a temp fact table for records that have been created after DB clone start time. (pxoutcometime > XXXXX, where XXXX is the DB clone start time)
- Delete records identified in step 1.
- Insert records into 8.6 fact from 7.3 fact which have pxoutcome time > DB clone start time.
- Check if records in Step 2 are present in 8.6 fact, if not then load them into 8.6 fact.
Thanks, Kiran