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