On 19 Aug 2004, jared_at_hwai.com wrote:
> I have an interesting problem: I am writing a small function to
> generate a surrogate key. The function will be part of a
> statement populating a table with data from four different
> databases (identically structured, located in four geographic
> sites). Each database is part of a different domain. I will
> use four separate SQL*Plus queries (or PL/SQL functions) to
> populate said table, identical except for the database links
> used. I want a subset of the domain value to be part of the
> surrogate key.
First things first. This is wrong design. You are putting
intelligence in keys. A definitely bad thing to do. The domain
needs to be an attribute on the table being inserted.
--
Galen Boyer
Received on Thu Aug 19 2004 - 15:03:10 CDT
