+11
We have SDE connected with an Oracle backend database
The proposal is to use FME Oracle Non-spatial reader, FME for update required tabular data and FME to write the record with updated tabular via FME Oracle Non-spatial writer. Geometry will never change just updating tabular data
Yes, I could use FME SDE Reader but when I looking a 400,000 spatial with tabular records, it's slow
QUESTION, will this damage the spatial record?
If you're only looking to update attribute data and not the geometry, I'd rather recommend using the SQLExecutor, it should be the best performing option since you can specifically target only the necessary columns to update, without touching the geometry column, e.g.
UPDATE my_table
SET my_attribute = 'new_value'
WHERE my_primary_key = 12345Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.