Dealing with denormalised data
ColinMackay
Posts: 4 New member
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:
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.
The relevant parts of the schema are:
Employee:
- Id: Int PK
- FirstName: nvarchar
- Lastname: nvarchar
- 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.
Tagged:
Answers
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
Have you visited our Help Center?