Target Rules H

Description

Click to run the selected rule immediately in the foreground.

Click to reset the processing status if a process fails for the selected target rule.

Click to open the Debug – Breakpoints page to add breakpoints to steps in the process for the selected target for target rules. Use breakpoints to debug issues with failed processing.

Displays the order the target rule is processed.

Displays the status of the target rule.

Displays the action the rule will take. Options include:

• Delete – Delete only rules.
• Insert – Insert only rules.
• Manual – All rules.
• Move – Move only rules.
• Update – Update only rules

Displays the view created in SQL server for the selected target rule.

NOTE: Only views that follow the proper naming convention display. Refer to Naming Conventions for more information.

Displays a description of the rule.

Displays the last date the target rule was processed.

Displays the number of records affected by the target rule’s execution.

Displays the amount of time Transform took to process the selected target rule. If the field is empty the target rule has not been processed.

NOTE: If a process takes less than 0.5 seconds to run, the duration in the DURATION field is 0.

Click to open the Monitor page to monitor the background job processes for the selected target rule. If a rule has no data to process, this icon is disabled.

Description

Click to reset the processing status if a process fails for the selected target rule.

Click to open the Debug – Breakpoints page to add breakpoints to steps in the process for the selected target for target rules. Use breakpoints to debug issues with failed processing.

Displays the name of the view stored in the target database that corresponds to the selected target rule.

Rule Automation Information

Displays the action the rule will take. Options include Delete, Insert, Manual, Move, and Update.

Displays the view created in SQL server for the selected target rule.

Displays the title of the table in SQL corresponding to the view.

Click to build a new rule based on the target rule.

NOTE: If a rule already exists, it is overwritten.

Status Information

Displays the order the target rule is processed.

Displays the status of the target rule.

Description

Displays a description of the target rule.

Displays user-entered comments about the selected target rule.

Displays an option to indicate if a target rule adds records, deletes records or is informational. If a data audit is conducted to determine if all data records were loaded (as they were expected to be loaded), the Recon Type justifies why records were not loaded. Use the options Adds records (+) or Deletes records (-) include or exclude, respectively, on certain exports (delta loads, multi-step loads, etc.) from the Target Reconciliation Report.

Click to open the Target Rule Audit page to add, edit and delete an audit report with a sample method for the target rule and to download the results.

Displays hyperlinks and supporting commentary that demonstrate the connection from data-related assets in the Stewardship Tier to external references in other platforms and applications.

Syniti recommends a Target Rule be linked to a Term or Rule in Syniti Cloud.

Description

Displays the date Transform processed the selected target rule.

Displays the number of records affected by the target rule’s execution.

Displays the amount of time Transform took to process the selected target rule. If the field is empty, the target rule has not been processed.

NOTE: If a process takes less than 0.5 seconds to run, the duration in the DURATION field is 0.

Click to process the target rule in the background. View the status of background processing on the Monitor page.