Dealing with denormalised data

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.

ColinMackay June 21, 2019 13:28

Comments

1 comment

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

Alex B June 24, 2019 12:59

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Dealing with denormalised data

Comments

Add comment