Deleting the key source

To delete the surrogate key source, design a flow that uses a Surrogate Key Generator stage by itself, with no input or output links.

  1. Open the Surrogate Key Generator details pane.
  2. On the Stage tab, in the Properties section, define the key source properties:
    1. Select the source type.
    2. Type or browse for the source name.
    3. Set the Key source action property to Delete.
  3. Optional: In the Advanced section, change the processing settings for the stage.
  4. Click Save to save your changes and to close the Surrogate Key Generator details pane.