Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Data masking algorithm in OEM needs change.

Mahesh Pednekar
MrMember Posts: 34
I tried to use OEM to mask the SSN numbers. But the issue is, OEM uses a function/algorithm to generate a random masked SSN number that maches with some existing SSN number. There is a need to change the algorithm that generates a unique SSN number.
Comments
-
The problem is an algorithm that generates unique numbers, when the original numbers are not unique, will change the cardinality of the table.
This affects the testing because you want the size of the result sets to be close to what's in production.
You also want the execution plans to be the same as production.
Everything changes when you change the cardinality of the data, and your testing becomes less meaningful.