After a lot of wrestling with the Script Activities containing SSJS for removing unwanted rows from my DEs and noticing that there are limits on the number of rows they can delete in a
for-loop (2500) and how slow that process is, I have decided to delete rows using SQL Query activities and staging (temporary) DEs.
To this end, I will have to rewrite the DEs that are connected to my contact model on a daily basis. I still use delta (diff) files for updating but at some point, I would have to empty my main DE and insert and adjust the correct data in a temp DE (with new rows added, current ones updated and the deleted ones removed) back to the main DE.
I am wondering if there are any consequences to this approach, knowing that a journey in Journey Builder can have an entry point DE that updates its data based on the contact model. Does disappearing/reappearing of records in a DE affect my journeys (or anything else)? Would it be new journey's triggered? Would existing data re-entered every day be treated as new rows?