Within our environment, we have had many databases added and assimilated due to several mergers and acquisitions of companies that were in a similar business.
As a result, we often come across the use of different data type for the same field e.g. TIN (tax identification number) for any provider.
Whereas in some places it is defined as VARCHAR2(9-10 digit), in some places it is defined as (NUMBER).
This poses a serious challenge to our data, as our masking does not return consistent results.
Can you suggest a way this inconsistency be overcome while using FormatEncrypt function?
Test Data Manager
Fast Data Masker