Re: Table modifications

Hi,

>table. There will be 1 to N tables which hold
>data provided by customers. I want to merge
>these tables nightly into a single table which
>holds 3 or 4 fields being populated by data in
>the other tables. I want to only implement
>changes to the data nightly. Insert only if
>record doesn't currently exist, update only if
>the data is different, etc. What kind of
>strategy is best for handling this scenario?

I think one complex snapshot (with aggregation) will be perfect for you situation.

• Martin (mje_at_telebot.com)

  ---