Hi Billy,
thanks for your response ...
I am not able to access the any seed table which is present under gtrep_reference_data under masking option. However, i am able to connect with the gtrep_reference_data and also able to see the data category..
------------------------------
Nitin Dixit
------------------------------
Original Message:
Sent: 10-11-2019 05:05 AM
From: Billy Keefer
Subject: Data masking data consistency between 2 different schemas.
If I understand the set up correctly, the easiest thing to do is to set up or create a new seed table that contains the information. For example
Seedtable
Fname Lname email
john smith john.smith@acme.com
jim jones jim.jones@acme.com
You would use the member id as the hashlov key and it would select the first and last name for schema 1 (column 1 and column 2) and using the same member id for schema 2 it would select the email address (column 3) for the same first and last name.
regards
Original Message:
Sent: 10-10-2019 04:10 PM
From: NITIN DIXIT
Subject: Data masking data consistency between 2 different schemas.
Hi team,
I have a requirement to mask DB tables across different schema. For example I have a schema1 with 1 employee table which contains first name and last name and these fields I am masking using HASHLOV and one more column assume it as a memberid and I have another schema2 which contains x_memberid and email ID's (masking required with reference of schema 1 employees first name and last name). In schema 1 we can use the Comcast with in same tables but how to do it if email column is in different schema and we don't have first name and last name there.
Can please suggest the steps to achive this.
------------------------------
Nitin Dixit
------------------------------