When working with a File Geodatabase Writer, FME gives us an option(FME Parameter) to "Overwrite Existing Geodatabase" or not!
Can someone Please let me know if there is such a option when dealing with a SDE Geodatabase?
So how we can prevent duplicating (appending data again into existing dataset) when we want to load data into?
Thanks
The "over write existing gdb" deletes the entire GDB and makes a new one, something you wouldn't want to do with SDE.
The appropriate solution would be to read in your SDE data and run it through a change detector with the "new" data and see if its an insert/update/delete/no action.
Alternately (as you don't specify your FME version) you can do an Upsert which will insert new features, and update existing ones