Achieving data consistency across multiple tables with and without using seed table in CA TDM

[Kirankumar Vishwakarma]

Hi Team,

I have the below requirement for data consistency across three tables in CA TDM: 

Table 1

Id | first_name | last_name

1  | John       | Doe

2  | Mary       | Smith

 

Table 2

Id | full_name

1  | John Doe

2  | Mary Smith

 

Table 3

Id | email

1  | [e-mail]

2  | [e-mail]

and I want data to be consistent post performing masking operation. kindly provide solutions for both approaches:

1. Using seed list
2. Without using seed list.

Looking forward to your response. many thanks.