Forum Discussion
creating new tables
many thanks for your inputs, littlemojopuppy.
i'll consider them accordingly.krgds, -nik
Hi Anonymous
Regarding the first question: that really depends how much memory/horsepower your computer has. Everything is held in RAM so if the computer is a weakling, the effective limit will be smaller. It will also depend on how well your data is modeled.
And regarding modeling, I'd suggest not having tables for individual years. I'd merge them all into a single table with Year as an attribute of that merged table. Will make writing measures easier. And you shouldn't have to create smaller files for carrier/origin/destination. That will just complicate things too.
Hope this helps! 🙂
many thanks for your inputs, littlemojopuppy.
i'll consider them accordingly.
krgds, -nik