Re: Integrity question

Yes, I load the same kind of junky data into data warehouse schemas. If I am in a hurry (most always) I add an number column to the table and populate in with a single update statement.

You could use trigger to do the same thing, but I am not sure that you would gain much by it.

When I have time, I get documentation and try to create real referential integrity.

Rock.

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!