Have to blind PII data before loading the data to anonymized layer such that it can't be traced back but also need to maintain the referential integrity between all the tables across all key columns. What is the most suitable way to blind data in this scenario.
Have looked at different blinding techniques but not able to find the one which would keep the referential integrity after blinding the key columns