Hi Haresh,
If your data contains any PII at all, I would recommend one of the following 2 approaches:
- Fully anonymize the data to be loaded into non-prod by replacing the PII with an obvious "dummy" value, i.e. "XXXXXXXXXXXXXXXX" or "000000000"
- Create synthetic test data that "looks" like prod, but does not contain any "real" PII
If the purpose of the non-prod load is to test your merge/match rules, you will need to ensure that whatever data you load into non-prod makes sense for the test without exposing any "real" PII.
Regards,
Walt
------------------------------
Walt Feldman
Solutions Architect
Tenerity
------------------------------