Greetings-
I am working on a work-flow process that will automatically update the attributes of a specific feature class from a scheduled python script that will run overnight. Here is what I am trying to accomplish:
Feature Class: Service Locations (Electric Meter Locations with account, meter and location data stored in our CIS system.)
I currently have a python script the pulled the data from our Oracle System and produces it into a Geodatabase table that sits in the same geodatabase as the Service Location feature class. What I need to do is to take the individual fields from the table and update the fields in the feature class.
This is what I have done:
I made a data model through model builder to 1) Make a Feature Layer 2) Add Join 3) Calculate Field (Update the feature class field with the same field from the data table.
Problem is - when I run the data model or the script - it takes a LONG time. The one script I build and tested only have 7 fields (so 7 Calculate Field processes) and it took about 4 hours to run.
Is there an easier way to do this?
Thanks in advanced
