i use enterprise guide to load tables daily..about 8 gig of data. we do a complete clean and replace concept. so yes the 1 gig table i load taday is completely reloaded tomorrow plus any added records.  some of our data is updated in ms sql table so simply doing an ADD of new records is not feasible for all our tables.   however, what was pointed out to me was and ADD feature in the data preparation tool on the va hub. it somehow will only add new records, but i havent researched it.   ... View more