April 2, 2015 at 11:36 am
Am I missing something ( probably am), but I don't see how or why this is better than using a surrogate key and join clause. If it needs to be simple for queries, write a view.
April 2, 2015 at 2:37 pm
The point of the tiny fact table and foreign key is that to add new items is an INSERT. To change the check constraint you must drop the old check constraint and add the revised version back.
April 6, 2015 at 11:26 pm
Neither do you need a join. In a view you would still be using a join.
Viewing 3 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply