Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Discard the link-table and just concatenate the fact-tables.
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?