topic Link Tables in App Development

Link Tables

GHDES_CAP — Mon, 27 Nov 2023 17:02:00 GMT

Hello,

I'm working on a data model and I have a question about relationships in a link table.

Dim1:

Dim1key,

Field1

Field2

Fact 1:

Fact1key,

DimKey1,

Field3

Fact 2 :

Fact2key,

Fact1key

Field4

Link table:

Fact1key,

Fact2key

Dim1key

How could I display a table with the following columns:

Field4 Field1

Thank you!

Re: Link Tables

marcus_sommer — Tue, 28 Nov 2023 08:05:51 GMT

Discard the link-table and just concatenate the fact-tables.

Re: Link Tables

GHDES_CAP — Tue, 28 Nov 2023 08:09:56 GMT

Thank you for the response.

I have to use a link table. The data model contains more than 50 tables.

Re: Link Tables

marcus_sommer — Tue, 28 Nov 2023 08:26:03 GMT

The more source-tables needs to be included the more important is to merge (vertically as well as horizontally) all tables as much as possible to end ideally by a star-scheme with one fact-table and n surrounding dimension-tables.

Of course it could mean a lot of work to clean and prepare all data-structures including filling + populating data and harmonizing all field-names and data-structure - but thinking you could avoid it by applying link-tables and saving efforts it's an illusion because the opposite will happens by doing all the needed work within a much more complex data-structure. Further link-table models could decrease the performance very significantly and the the UI experiences are also bad. In short: just getting disadvantages without any benefit - therefore why doing it?