Does good database design give the best results in QlikView?
For anyone who has been involved with database design, for many years the philosophy has been to have a fully normalized data structure. For those who don't know what this means, in simplistic terms, don't store anything twice. So, if you have, for example, a
Manufacturer Name in each
Product record, you should create a separate table to hold all the
Manufacturer Names and a
Key and then just store the appropriate
Key in each of the
Manufacturer Name will only be stored once in the database, taking up less space.