Yes the primary key is the basis for whether a row is unique or not.
Best, Hal Steiner
-----Original Message-----
From: Kent Olsen <[Email address protected]
To: [Email address protected]
Sent: Thu, 21 Jun 2007 5:05 pm
Subject: Re: Interesting Problem
**A LazyDBA.com subscriber has responded to your lazydba.com post**
*LazyDBA.com mail shield has forwarded you this email,
*and removed any attachments, and kept your email address secret
*from this person, and any viruses/trojans.
*If you reply to this email, the person will see your email address as normal
*Anything below this line is the original email text
Are there unique keys to be considered?
How do you consider a row "unique"? If any data item is different or if
pecific data items vary?
Dear Fellow Lazy DBAs:
Here is an interesting problem - I'm looking for outside the box solutions.
Imagine you have 8 tables which have identical logical structure and about 99%
f the data is the same, but there are some differences - anomalies. You wish
o "merge" this data into a new table eliminating all duplication and
onsolidating data so that if a row appears even in only one of the 8 tables it
ill appear in the merged result.
I will add that the tables are quite large - let's say between 1/2 million and
million rows each - and you have to run this job semi-frequently so total
lapsed run time is important. Efficiency is very important. Of course the 8
ables are on separate servers/instances of DB2.
Any takers?
Best, Hal Steiner
________________________________________________________________________
AOL now offers free email to everyone. Find out more about what's free from
OL at AOL.com.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
________________________________________________________________________
AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com.
DB2 & UDB email list listserv db2-l LazyDBA home page