Creating SCV Data Enhancement Rule

To create a new data enhancement rule:

  1. Select Configuration > SCV > Data Enhancement Rules.
  2. Click New.
  3. Specify this information in the Details tab:
    Name
    A unique name of the data enhancement rule in SCV.
    Note: You cannot modify this field after the creation.
    Description
    The description of the data enhancement rule.
    Target Table
    The name of the target table selected from SCV. The possible table types:
    • Staging
    • Inbox
    • Core
    • Outbox
    Target Column
    The column name of the specified Target Table.
    Default Value
    The value that is applied when the data rules do not return any value.
    System
    Indicates if the data rule is system defined or user defined.
    Note: This option is enabled for the data rule defined by the system.
    Enabled
    Indicates the status of the data rule. Possible values:
    • On (Enabled)
    • Off (Disabled)
    Note: The enabled data enhancement rule must be included in the transformation logic.
  4. Click the Table Link tab.
  5. Click '+' to specify the link between the target table and the source table.
  6. Specify this information:
    Source Table
    The name of the source table. Possible table types:
    • Staging
    • Inbox
    • Core
    • Outbox
    Note: You must not select the table name used in the link definitions.
    Target Table
    The name of the target table. This value is defaulted from the Details tab.
    Foreign Key Constraint
    The foreign key constraint between the source table and the target table (Source table > Target table and Target Table > Source table).
  7. Click Add. A new row is added to the Table Link list.
  8. Click the Data Rules tab.
  9. Click '+' to specify a new data rule.
  10. Specify the Value to be applied based on the filter setting.
  11. Specify this information in the Filter section:
    Filter Condition
    The filter condition. Possible Values:
    • AND
    • OR
  12. Click Add Condition to specify this information:
    Table
    The name of the table. Possible values:
    • The target table defined in the Details tab.
    • The source table defined in the Table Link tab.
    Column
    The column name of the defined Table.
    Operator
    The operator used for setting the filter condition. Possible values:
    • Equals
    • Not Equals
    • Like
    • Is Null
    • Is not Null
    Value
    The value to which the filter condition is applicable.
    Note: The value must be enclosed in single quotes.
  13. Click Add Sub Condition (if applicable) to set additional filter condition.
    Note: 
    • You can view the specified conditions in the Preview section using the Preview option.
    • You can delete the filter conditions using the Delete options corresponding to the Condition or Sub Condition.
  14. Click Back to Data Rules. The specified filter condition is saved as a Data Rule. You can view this Data Rule in the Data Rules page.
  15. Click New. A new data enhancement rule is created.
    Note: You can use this page to:
    • Create a duplicate of the existing data enhancement rule and modify the parameters as required using the Duplicate option.
    • Delete data enhancement rules using the Delete option.