Updating the state file (DataStage®)

To update the state file, add a Surrogate Key Generator stage to a flow with a single input link from another stage. If the state file does not exist, you can optionally create it in the same flow.

1. Open the Surrogate Key Generator details pane.
2. On the Stage tab, define the stage properties in the Properties section:
   1. Set the Source Type property to Flat File or Database sequence.
   2. Specify a source name in the Source name field.
   3. If you chose Database sequence, select Oracle, ODBC, for source connector and specify a source connection.
      Note: The password for the connection must be parameterized to an encrypted password to run end to end.

      If you selected ODBC source connector, then you can choose the Data source type: Snowflake, Db2®, or Oracle. When you choose Snowflake, then you can only use Flow connection.

   4. Set the Key source action property to Update, or if the state file does not exist and you want to create it, select Create.
   5. Optional: If you chose Database sequence, select additional properties of sequence block size and sequence initial value.
   6. Select the input column to update the state file.
      The input column usually is the surrogate key column.
   7. Optional: On the Advanced tab, change the processing settings for the stage.
3. Optional: On the Input tab, define the input data to the stage:
   1. In the Partitioning section, change the partition settings for the input link.
   2. In the Columns section, configure columns as needed.
   3. In the Advanced section, change the buffer settings for the input link.
4. Click Save to save your changes and to close the Surrogate Key Generator details pane.