I'm currently stuck in my FME Workspace script. Ideally, I'm reading from a file geodatabase and will update the SDE database in SQL server. I have CRC calculators to check for the changes in the Attributes and Coordinates and if the 2 CRC values are different then i will use the data from the File GDB to update the SDE database.
This is a screenshot of my workspace:
The issue that i am encoutering is it always updates the data because the geometries being stored in the SDE database is not the same with the geometries in the File GDB.
I modified the SDE writer feature type to match the X,Y Origin and scale from the File GDB feature class and disabled the "Simplify geometry" but the coordinates stored in the SDE Database are still changing.
These are the coordinates from the File GDB and the coordinates stored in the SDE Database:
Also both the SDE and File GDB have the same spatial reference.
I am quite stumped about this. Tried alot of things but it still automatically changes the coordinates when saved to the SDE database.
Any ideas will absolutely be helpful.