15 Primary Keys for a fact table

surfdb · #1 (**permalink**) 03-31-06, 01:07

Hi,

I've a developer requesting for 15 primary keys for a fact table. This table will possibly join with many dimension tables.

Is this a good move ?

And if there's bulk loading into this table, will it cause any problem ?

Advice pls...TIA

Marcus_A · #2 (**permalink**) 03-31-06, 01:16

You can only have one Primary Key per table. Do you mean one PK with 15 columns, or 15 foreign keys (or both)?

surfdb · #3 (**permalink**) 03-31-06, 03:59

1 PK with 15 columns.

Internet Services

Web Development

Digital Marketing

Consumer Tech