Wednesday, September 17, 2014

Two quick answers on RPD design: Foreign Keys

Why must line must be drawn from fact to dim in physical diagram join?

  When you create the join between the two tables, the table at the start point of the drawn line will be where the foreign key object will be created that describes the reference from the fact to the dim.  If one does not already exist, a key object will also be created on the join column(s) on the table at the end point of the drawn line (the dimension). So foreign key on fact, key on dimension as would be expected in a 1:M join.

Why should you uncheck foreign keys when importing tables?

The only references I could find to unchecking this box during import suggested that including the foreign keys might make the import take longer.    If the foreign keys are imported, it would still be a good idea to review all join conditions between the tables after importing.

No comments:

Post a Comment