Flow table with Origin and Destination, should I create 2 lookup tables or use LOOKUPVALUE?

[olivierhbh]

Hello all,

I have a flow fact table with origin and destination code columns, plus a country lookup table which is related to an area table.

Performance wise, should I
- duplicate the country and area tables, prefix them with origin and destination and create relations?
- or use only 1 lookup table of each kind and import values into fact table with LOOKUPVALUE?
- or another option ?

Thanks in advance for your help.

Olivier.

 

[Matt Allington]

There is no one correct answer. If you want to slice and dice using filters where you filter both the origin and the destination, then 2 tables is the best approach. As for performance, you would have to test it. If you workbook is small (say only a couple of million rows) then performance probably is not an issue either way.

 

[olivierhbh]

Hi Matt,
Thanks for your answer. My workbook is small, it's about 400k rows, but I use Excel 2010 32 bits, and it easily raises the error about lack of resources, that I should go into 64 bits version, which is not an option for now.
I guess I'll have to try both ways.
Thanks,
Olivier.