Purge activity in Demantra tables
Team, We are purging few combinations from mdp_matrix table due to incorrect data or obsolete data or incorrect combinations.
We identified these records and deleted it from mdp_matrix table.
We dont want to delete its corresponding records in level tables, as the level members are valid and not the combination in mdp_matrix table.
We are also purging corresponding incorrect item_id and location_id combination record in sales_data table.
Basically we are purging data in mdp_matrix and sales_data table.
Can we know while performing this activity, do we need to take care of anything else?