Are there unique keys to be considered?

How do you consider a row "unique"? If any data item is different or if specific 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% of the data is the same, but there are some differences - anomalies.  You wish to "merge" this data into a new table eliminating all duplication and consolidating data so that if a row appears even in only one of the 8 tables it will appear in the merged result.
>
>I will add that the tables are quite large - let's say between 1/2 million and a million rows each - and you have to run this job semi-frequently so total elapsed run time is important. Efficiency is very important.  Of course the 8 tables 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 AOL 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
>
>



DB2 & UDB email list listserv db2-l LazyDBA home page