Insert Feature with multiple Geometry column in oracle spatial

Hey all,

 

 

I too am trying to populate multiple geometry columns but in PostGIS. hopefully someone can provide insight into possible methods applicable to any dbms that supports multiple spatial fields. I am building out a spatial ETL using the ArcGIS Interoperability ext. Source is a MSSQL Spatial table with two point geometry columns, target PostGIS table same schema as source. I found this thread in the deprecated FME Talk group on GGL https://groups.google.com/forum/#!topic/fmetalk/PVf6yIGASrk here some other folks provided possible ways to update/insert views of the table that contains mulitple spatial columns. One option would be to use the standard spatial writer for your dbms for one column and OGCWKT to populate geometries for the second column. I am trying to do this fully within workbench. Still unsure of how to execute the OGC method in workbench using sql. Some folks are under the impression that working with multiple spatial columns is rare but it's not that's why the major dbms vendors prop & opensource support this architecture.