I'm working with several large polygon data sets which can be both stand alone shape files or feature classes
from a FGDB. The end destination is a SQL sde database, is it best practice to load directly to SDE or first
load to a staging GDB (perform data prep, ie--> rename, geometry checks/repairs, re-projections...etc) then load to SDE?
The data sets will be loaded and reloaded on a regular basis. I would like to do a nightly compare and load new data in an automated fashion.
Thanks for any feedback on the topic