Posted: Wed Jul 18, 2007 3:00 pm
What else IS there?
To ensure referential integrity the ONLY technique (irrespective of how you code it) is to verify that the value occurs in the parent (dimension) table.
To ensure referential integrity the ONLY technique (irrespective of how you code it) is to verify that the value occurs in the parent (dimension) table.