AnsweredAssumed Answered

Function to generate 11-proof check numbers through Fast Data Masker

Question asked by abhinav.bhatnagar on Jun 13, 2017
Latest reply on Jun 13, 2017 by dovle01

We have 2 tables which are joined by customer id (key field). This is a valid 11-proof number.  We have a requirement to mask customer id in both tables ensuring consistency and 11-proof check. 

 

Is there any function which generates 11-proof numbers and also helps us manage the relational integrity. If not, can we create a seed by generating valid 11-proof numbers and create a mapping between original customer id and generated 11-proof id such that the data is masked consistently based on this seed.

Outcomes