Transform
Target Source Rules H
Target Source Rules V (All Tabs)
Use the page to Add Target Source Rules.
NOTE: Bulk Execution has been enabled on this page. Refer to Use Bulk Execution for more information.
To access this page:
- Access Transform.
- Click the Targets icon on the Process Area Launch page.
- Click the Sources icon for a Target.
- Click the Rules icon for a Target Source.
|
Field |
Description |
|
Execute |
Click to run the selected Target Source rule immediately in the foreground and to create the stored procedure from the view. |
|
Reset |
Click to reset the processing status if a process fails for the selected Target Source rule. |
|
Debug |
Click to open the Debug – Breakpoints (Target Sources) page to add breakpoints to steps in the process for the selected Target Source for Target Source rules and Target Source reports. Use breakpoints to debug issues with failed processing. |
|
PRIORITY |
Displays the order the Target Source rule is processed. |
|
STATUS |
Displays the status. Only active rules are run. |
|
RULE TYPE |
Displays the action the Target Source rule will take. Options include Delete, Insert, Manual, Move, and Update. |
|
SOURCE RULE VIEW |
Displays the view created in SQL server for the selected Target Source rule. NOTE: Only views that follow the proper naming convention display. Refer to Naming Conventions for more information. |
|
DESCRIPTION |
Displays a description of the Target Source rule. |
|
ACTION ON |
Displays the last date the rules was processed. |
|
RECORD COUNT |
Displays the number of records affected by the Target Source rule’s execution. |
|
DURATION |
Displays the amount of time Transform took to process the selected Target Source rule. If the field is empty, the 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. |
|
Queue |
Click to open the Monitor page to monitor the background job processes for the selected Target Source rule. If a Target Source rule has no data to process, this button is disabled. |
Target Source Rules V All Tabs
Use the page to Add Target Source Rules.
This page has the following tabs:
General tab
|
Field |
Description |
|
Reset |
Click to reset the processing status if a process fails for the selected Target Source rule. |
|
Process |
Click to process the Target Source rule in the background. View the status of background processing on the Monitor page. |
|
Debug |
Click to open the Debug – Breakpoints (Target Sources) page to add breakpoints to steps in the process for the selected Target Source for Target Source rules and Target Source reports. Use breakpoints to debug issues with failed processing. |
|
Source Rule |
Displays the name of the view stored in the target database that corresponds to the selected Target Source rule. Click to open the Definitions page to view the SQL definition of the rule. |
|
Rule Automation Information |
|
|
Rule Type |
Displays the action the Target Source rule will take. Options include Delete, Insert, Manual, Move, and Update. |
|
Source Rule View |
Displays the view created in SQL server for the selected Target Source rule. |
|
Source Rule Table |
Displays the table in SQL that corresponds to the view. NOTE: For insert or delete rules, this field must be blank. |
|
Build Rule |
Click to build a new Target Source rule or to build an updated Target Source rule after updates have been made. If a rule already exists, it is overwritten. |
|
Status Information |
|
|
Priority |
Displays the order the Target Source rule is processed. |
|
Status |
Displays the status. Only active Target Source rules are run. |
Documentation tab
|
Field |
Description |
|
Description |
Displays a description of the Target Source rule. |
|
Comment |
Displays user-entered comments about the selected Target Source rule. |
|
Recon Type |
Displays an option to indicate if a Target Source 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. |
|
Audit |
Click to open the Target Source Rule Audit page to add, edit and delete an audit report with a sample method for the Target Source rule and to download the results. |
|
External Reference |
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 Source Rule be linked to a Term or Rule in Syniti Cloud. |
Process Information tab
|
Field |
Description |
|
Action On |
Displays the date Transform processed the selected Target Source rule. |
|
Record Count |
Displays the number of records affected by the Target Source rule’s execution. |
|
Duration |
Displays the amount of time Transform took to process the selected Target Source rule. If the field is empty, the Target Source 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. |
