network profile
| bio | website | infoadvisors.com |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 4 months |
| seen | Mar 14 at 5:04 | |
| stats | profile views | 17 |
|
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 |
