Data modeling

[jumiprado]

Hi guys, i have a serious problem with My data, i have 22 tables from informix database where each table have two or more fields equals like clientID, CaseFile_Id, AreaId...

I have CaseFile_historic, CaseFile_actual, Grouped_CaseFiles.

When i requested the keys fields the it area gave me indexs fields.

When i load the data i have synthetic keys,

How can i made a Good data model?

[Thiago_Justen_ · Accepted solution]

There are many things you can do. I suggest you theses aproaches:

MASTERTABLE (LINK TABLE or Concatenated FACT Table)

Resolve synthetic keys

Synthetic keys vs. AutoNumber() (- concatenation)