Skip to main content
Question

Creating Running Integer Surrogate Key for Geodatabase

  • September 21, 2020
  • 1 reply
  • 13 views

I am trying to set up a Spatial Data Warehouse within a geodatabase. How can I get FME to create and maintain a running-integer surrogate key for my feature classes and tables? The surrogate key is a replacement for the primary key that has to remain unique and should be in a running integer format for every new row inserted into a feature class (e.g. 1, 2, 3, 4, ... 101, 102, 103).

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

anhphuongt
Forum|alt.badge.img
  • September 21, 2020

Can the transformer Counter help you then? It will increment everytime there is a feature passing through and you can also set the count start.