Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to do some improvements on a app and have some doubts.
I’m working on an application with a lot of data and with many sheets and objects. I have tried to keep the data model as a star schema as much as possible.
While thinking of more ways to improve the data model, I noticed that many of my dimension tables are linked to my facts through the same key but using different field names.
My question is then the following: If I rename these keys with the same name, in order to minimize app size by reducing the amount of symbol tables, will the app work normally or will this be the same as a circular reference?
In case my question is not clear, check the image below where you can see the type of link that I’m thinking of creating.
I have also tried keeping different names for all the key fields and then applying "Autonumber <fieldname> using Keys" but when running the document analyzer I didn't see any performance improvements and the app size somehow actually increased.
