skeezwiz (9/1/2014)
yes I know its a star-schema, but its not for the purpose of a warehouse/cube solution. This is a day to day system and the only design change I can think of for them to full fill an unlimited number of lookup items requests is to have Main table(id,code,name,description,<xml containing any number of child lookup data>), has anybody done something like this before?
Quick thought, although a generalized lookup table might indeed cover many of the tables and be more flexible in terms of adding new "types", the benefits are quickly outweighed by the penalties on the processing side of things.
😎