Creating SCV Data Enhancement rule

To create a new data enhancement rule:

  1. Select Configuration > SCV > Data Enhancement Rules. The Data Enhancement Rules screen is displayed.
  2. Click New.
  3. Specify this information on the Details tab:
    Name
    A unique name of the data enhancement rule in SCV.
    Note: You cannot modify this field after creating the rule.
    Description
    The description of the data enhancement rule.
    Target Table
    The name of the target table selected from SCV. The list contains all tables that are any of the following types:
    • Staging
    • Inbox
    • Core
    • Outbox
    Include extension columns
    Indicates whether to include extension columns related to the selected Target Table.
    Note: 
    • This switch is displayed only if the value of the Target Table field is set to a Core table.
    • By default, this switch is set to Off.
    Target Column
    The column name of the specified Target Table.
    Note: 
    • If the Target Table field is set to a Core table and the Include extension columns switch is set to On, columns are populated from the (SC_V_EXT_<table>) extension view corresponding to the selected Core table. The res_xxx columns are excluded from the list.
    • If the Target Table field is set to a Core table and the Include extension columns switch is set to Off, columns are populated from the selected Core 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: If the Enabled switch is set to On, the data enhancement rule is 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. Select from a list of all tables of type:
    • Staging
    • Inbox
    • Core
    • Outbox
    Note: Tables used in previous table links are excluded from the list.
    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. Select a value in the Rule Type field. Possible values:
    • Table Column
    • Constant
    • Expression
    • Keywords
    • Configuration Parameter
    • Application Default
    Note: See, Rule types.
  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 (Alpha fields only)
    • Not Like (Alpha fields only)
    • Is Null
    • Is not Null
    • Greater Than (Numeric and Date fields only)
    • Greater Than/Equals (Numeric and Date fields only)
    • Less Than (Numeric and Date fields only)
    • Less Than/Equals (Numeric and Date fields only)
    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. Select Back to Data Rules and click Back and Update changes. The specified filter condition is saved as a Data Rule. You can view this Data Rule in the Data Rules page.
    Note: You can also select Back to Data Rules and click Back and Discard changes. The specified filter condition is not saved.
  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.