Thank you Rajeev. However, after purging such profiles there will be lot of orphan orders [incomplete orders] in db. Will this create any issue ? I do have a purge incomplete order scheduler that runs every night. Just want to confirm that after the profile has been purged the incomplete orders attached to those profile won't create any issue if these orders are deleted at a later date.
I dont think it will create any issue since you are not going to do any operations such as checkout or load order for the orphaned orders. When you use the Purge order service as you mentioned these orders will get purged and the DB will be cleared. However you need to monitor the behavior for sometime and see if there any issues. You can add a logic to purge the orders associated with a profile when you remove the profile if the first option creates any issue.
Just to add that with ATG10.2, the repository asset purging is enhanced for profiles as well which you can configure from dyn/admin. Refer its documentation for more details