Dealing with denormalised data

ColinMackay

I'm trying to generate a table that for performance reasons uses some denormalised data. However, I cannot see how to pick this up from the source table.

The relevant parts of the schema are:

Employee:

• Id: Int PK
• FirstName: nvarchar
• Lastname: nvarchar

Appointment:

• EmployeeId : int FK
• EmployeeName: nvarchar (concatenation of Employee.FirstName, Employee.LastName)

Setting the EmployeeId was easy enough using the Foreign Key generator, however, I need to the EmployeeName to match the values from the Employee table.

Alex B

Hi @ColinMackay,

I believe you can do this with the Python Generator, but there is not a facility to link e.g. the firstname and lastname from one table into the employeename of another table.

This is possible using an insertion rule in SQL Data Masker https://documentation.red-gate.com/dms6/data-masker-help/masking-rules/about-insertion-rules

I hope this helps!

Kind regards,
Alex