Forum Discussion
Solved
How not to relate two data tables
Hi there, sorry for silly title. It ought to read: how to not relate two data tables given the circumstances in my specific case. But I guess that would have been too long. Say I have two data t...
You only have one fact-table here: Table 2 with the details. Table 1 is a lookup-table (for the transaction details, with unique transaction key). So not only no reason at all not to link them together, but also no alternative :-)
Regard it as a formerly long and wide fact-table where someone was wise enough to split it up already into an optimized form (this process is called "Normalization")
I also don't understand what benefits Greg_Deckler intermediate table (1) should bring?
Hi #chefe
Can you please decribe in more details what is the business case you need to solve from linking these 2 tables ?
It would also help if you attached some example of your data
BIXL