Removing Synthetic Keys Made by EMP_id,Date,Year,Month,Period

[Anonymous]

Hi,

I have five tables A, B, C ,D , E and other Master file which have employee description. When I am loading it , It creates Synthetic Table which consists of EMP_id,Date.Year.Month,Period and Quarter.

Please suggests me the best way to avoid this and keeping association perfect.

Thanks in advance.

[anbu1984]

- Join the tables to create a single big table

Or

- Create Keys using Autonumber() and rename similar name fields as below

Load EmpId, Year, Autonumber(EmpId&Year) As EmpKey Table Employee

Load EmpId As EId, Year As Yr, Autonumber(EmpId&Year) As EmpKey Table Employee

[maxgro]

before removing it tries to read this post to see if you actually have to remove them

Synthetic Keys

if you still want to remove you can use

- autonumber as already suggested

- field1 & '|' & field2 & '|' & field3 as %key

- renaming fields

Best way depends on your model, if possible post it (table viewer)

[Anonymous]

This is the Data Model...Please prefer me the best way to avoid it