I'm working on a solution where I will be using Data Compare to transfer an existing database to a 'holding' db, I will then 'Mask' this data using the SQL Data Generator.
The resultant data will then be transfered to the QA environment via Data Compare again.
This solution requires multiple different databases to be 'Masked', however the data across these databases needs to be consistent, i.e. the Credit Card Number that becomes Obfuscated in both Databases needs to still be the same number when comparing these databases together (cross referencing in our applications).
I was thining of creating a lookup table, which will hold the real cc number as well as the 'created' cc number. and when I use the Generator use a SQL script to obtain the 'created' cc number.
How would I go about doing this?