Re: One table or many - need valid reasons.

David Aldridge wrote:
> One issue that I see is that the advantages that you list for option
2
> apply even more so to the option that you first eliminated -- adding
> new columns to the existing tables. I have a feeling that both of the
> two options you offer have sacrificed performance, integrity, ease of
> understanding, and ease of maintenance in favour of reducing the
> transient workload required in order to integrate a new backend
system.

I agree with everything David says. If you have any doubts about the advice he is offering see if you can make it to the end of this thread.

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:10678084117056

-- 
MJB