What are the challenges you face when working across database platforms? Take the survey

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:

  • 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.



Sign In or Register to comment.