MainFrame and SQL Masking (FORMATLUNH)
Article ID: 190195
Updated On:
Products
CA Test Data Manager (Data Finder / Grid Tools)
Issue/Introduction
1) I am using Formatluhn algorithm to mask SIN number with the check digit and it is working fine for SQL and Oracle DB. Do we have Formatluhn algorithm available while doing mainframe masking to achieve check digit while masking SIN number?or is there any other masking algorithm that is available on both mainframe and distributed side. For data maker version 4.7
2) Do we have any algorithm to mask account number while preserving check digit on both mainframe and sql DBs? For data maker version 4.7
3)While masking address fields i want to mask city based on first 3 characters of the postal code.For example,
if my postal code id L6S3E7 which belong to Brampton (canada) . I want the tool to look up postal code and only pick up cities based on L6S i.e for brampton and mask last 3 digits of the postal code ie 3E7.
For data maker version 4.7 and 4.9( just in case I am able to upgrade the tool)
I know this was functionality was enhanced in 4.9 version. Can you please me understand how to achieve it for both MF and SQL side for both ?
Please note above question will be used for both MF and Sql environment, please provide answers keeping this in mind. Thank you
Environment
Release : 4.7 and 4.0
Component : CA Test Data Manager - Mainframe
Cause
N/A
Resolution
Answers to questions:
1) I am using Formatluhn algorithm to mask SIN number with the check digit and it is working fine for SQL and Oracle DB. Do we have Formatluhn algorithm available while doing mainframe masking to achieve check digit while masking SIN number?or is there any other masking algorithm that is available on both mainframe and distributed side. For data maker version 4.7
FORMATLUNH and HASHIN are the new masking functions introduced under the US587356 user story. I would strongly recommend that you upgrade to TDM 4.9.0 and to TDM MF 5.4.18 as well. There are a lot of more fixes and features that are part of these new releases.
2) Do we have any algorithm to mask account number while preserving check digit on both mainframe and SQL Databases? For data maker version 4.7
The best solution here is FORMATLUNH for both mainframe and open systems. You could also use LUHN, but FORMATLUNH is the best solution.
3)While masking address fields I want to mask city based on first 3 characters of the postal code. For example,
if my postal code id L6S3E7 which belong to Brampton (Canada) . I want the tool to look up postal code and only pick up cities based on L6S i.e. for Brampton and mask last 3 digits of the postal code i.e. 3E7.
Do a where clause on that column, then do a PARTMASK to accomplish this. Please note, there is a performance hit, if you do this, so you might be better off using a subset first.
1) I am using Formatluhn algorithm to mask SIN number with the check digit and it is working fine for SQL and Oracle DB. Do we have Formatluhn algorithm available while doing mainframe masking to achieve check digit while masking SIN number?or is there any other masking algorithm that is available on both mainframe and distributed side. For data maker version 4.7
FORMATLUNH and HASHIN are the new masking functions introduced under the US587356 user story. I would strongly recommend that you upgrade to TDM 4.9.0 and to TDM MF 5.4.18 as well. There are a lot of more fixes and features that are part of these new releases.
2) Do we have any algorithm to mask account number while preserving check digit on both mainframe and SQL Databases? For data maker version 4.7
The best solution here is FORMATLUNH for both mainframe and open systems. You could also use LUHN, but FORMATLUNH is the best solution.
3)While masking address fields I want to mask city based on first 3 characters of the postal code. For example,
if my postal code id L6S3E7 which belong to Brampton (Canada) . I want the tool to look up postal code and only pick up cities based on L6S i.e. for Brampton and mask last 3 digits of the postal code i.e. 3E7.
Do a where clause on that column, then do a PARTMASK to accomplish this. Please note, there is a performance hit, if you do this, so you might be better off using a subset first.
Additional Information
Feedback
Yes
No
Powered by
