I am trying to develop data masking services using Optim Designer version 2.2.3. I have two related tables, lets say :
- Table A (X(PK),Y,Z)
- Table B (L(PK),M,N,X,Y,Z)
As you will notice, attribute X is a Foreign Key in Table B and that all the attributes in Table A (X,Y and Z) are present in Table B.
Correct me If I am wrong here, had referential Integrity being maintained, attribute Y in Table B should also have the same (masked) values in Table A right?
It will be very helpful if some one can help me with developing a service which masks data (in the scenario above) maintaining the referential integrity.