Masking DB2 Cross Reference Columns

In some circumstances, columns join between tables on data types other than simple numerical IDs. In this case, you want to consistently mask the data in these table columns, and maintain the context and data integrity. For example, mask a credit card number so that the number is still the correct format for this credit card type. 
tdm49
In some circumstances, columns join between tables on data types other than simple numerical IDs. In this case, you want to consistently mask the data in these table columns, and maintain the context and data integrity. For example, mask a credit card number so that the number is still the correct format for this credit card type. 
Prerequisite Steps
  1. Edit the script gtsrc_cross_reference.sql in your
    Data Subset install\scramble
    directory. Replace <DBNAME> with your DB2 schema name.
  2. Run the script gtsrc_cross_reference.sql in your DB2 source connection. The source is the DB2 database that you are to extract and mask.
Set Scramble Functions
Mask column data consistently across tables in your schema;
Do one of the following:
  • Select hash functions for basic numeric data
  • Select functions that begin with CROSSREF
The Subset Steps
  1. Select Run DB2 Windows Scramble as the action type.
  2. (Optional) Run DB2 UNIX Scramble as the action type.
  3. On the Data Scrambling tab, select your Datamaker project from the drop-down list. 
  4. Select your extract, and click Generate.