336 reputation
33
bio website infoadvisors.com
location
age
visits member for 2 years, 11 months
seen Mar 14 '13 at 5:04

Mar
13
comment What alternatives exist when a table requires too many foreign keys?
I've done many designs in this area - pricing, product management, product specifications. Even in highly normalized designs, I've never come close to that many FKs on the same table. Are you perhaps doing some sort of data partitioning strategy (by client or time or something like that) that caused you to design in this direction? It's difficult to provide an answer without some more information about your design and design goals.
Feb
20
comment How do I get ER Studio Data Architect to automatically add SCD Fields to my Dimensions?
David, I just did a test by modifying the sample macro to add 4 "audit" like columns. It seems to do what you are asking for. And all I have to do is select the entities, then do ALT+S and run the macro.
Feb
20
comment How do I get ER Studio Data Architect to automatically add SCD Fields to my Dimensions?
David, I did mean manually creating a template entity, then copying it everytime you want to create a new dimension. I would most likely create a macro for that, though, so that I could use a hotkey to do that instead of copy and paste.
Feb
19
awarded  Editor
Feb
19
revised How do I get ER Studio Data Architect to automatically add SCD Fields to my Dimensions?
Added new ideas
Feb
19
awarded  Supporter
Feb
19
answered How do I get ER Studio Data Architect to automatically add SCD Fields to my Dimensions?
Jan
28
awarded  Necromancer
Jan
16
awarded  Yearling
Jan
17
awarded  Necromancer
Jan
16
answered Should I split a single table with an AUTO_INCREMENT PRIMARY KEY into two tables that can be joined on that PRIMARY KEY?
Jan
16
answered Am I violating any NF rule on my database design?
Jan
16
answered How do you document your databases?
Jan
16
awarded  Teacher
Jan
16
answered Best way to document database mappings for migrations