I have a requirement to mask DB tables across different schema. For example I have a schema1 with set of tables which were masked and I have to ensure that the tables in schema2 also to be masked with the same values.
Can please suggest the steps to achive this.
For Better understanding
Here is my example:
Customer details db table Payment Details db table
So if i Mask the First name and Last name in Schema1 and i used the concat functin on Email column, so that i want to ensure the same values to be populated in schema2 as well.
Even within same schema also i have to solve this
Hope you understood the Problem
You can use a hash function like HASHLOV to maintain consistency across schema. You can read more about the functions in below link.
Masking Functions and Parameters - CA Test Data Manager - 4.3 - CA Technologies Documentation
Thanks for your reply, Yes HASHLOV has the mechanism that masks the value consistently but in my case there are other columns as well for example Email column i have used Concat function so that same value to be poplulated in other schema db table
As i have given the above example, the case is below
Customer Detail db table Consignee db table
FirstName -- HASHLOV function Email - this value should be same as
LastName - HASHLOV function Schema1 Custome Detail db table.(Please
Email -- CONCAT(FirstName.LastName@gmail.com Note in this table we don't have first name
and last name columns, only email column
where the value is expecting same as
schema1 db table)
Please let me know if my question confuses you.
Since you don't have the the name fields in the second schema, you could setup a cross reference table to hold the list of email values on schema1 and you can use the same cross reference value for email in schema2 so that the values are retained. Please see below link for more details.
Fast Data Masker Best Practices - CA Test Data Manager - 4.3 - CA Technologies Documentation
Thanks for your information, your inputs worked for me
Thanks a lot