Target Sources H
Use this page to Manage Target Sources.
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.
Target Sources V All Tabs
Use this page to Manage Target Sources.
This page has the following tabs:
General tab
Field
Description
Reset
Click to reset the processing status if a process fails for any of the Target Source’s Target Source reports or Target Source rules.
Process
Click to run the entire source in the background by importing all data from all sources and running all source rules and source reports in that order. View the status of background processing on the Monitor page.
NOTE: If the selected source is inactive, the Process icon is disabled.
Debug
Click to open the Debug – Breakpoints (Target Sources) page to add breakpoints to steps in the process for the selected Target Source, including Target Source rules and Target Source reports. Use breakpoints to debug issues with failed processing.
Source Information
Source ID
Displays the source name.
Source Database Object
Displays the name of the object that stores the source data.
Source Connection Type
Displays the connection type for the source import associated with a CranPort, SSIS or Data Services package. These imports can be from comma-separated text files, Excel Files, Access databases, SQL Server databases or ODBC databases, such as DB2 and Oracle.
Package Name
Displays the CranPort, SSIS or Data Services import package name. This field does not display if the CONNECTION TYPE set on the Target Source page’s Horizontal View is None.
The naming convention for packages is #Database#%#Source#%, for example dswBRAZIL.stKNA1_QALegacyData_Customer.imp for an import or dswBRAZIL.stKNA1_QALegacyData_Customer.exp for an export.
Truncate Before Import
If checked, a source table is truncated before an import package is run against it. This field does not display if the CONNECTION TYPE set on the Target Source page’s Horizontal View is None.
Status Information
Priority
Displays the order the source is processed.
Status
Displays the status. Only active sources are run.
If Source Active On Build is enabled on the Parameters page in Console, target sources are auto-generated with a default status of active in Transform. If disabled target sources are auto-generated with a default status of inactive in Transform.
Contact Information
Primary Developer
Displays the name of the primary developer responsible for the target. This field is for documentation purposes only.
Secondary Developer
Displays the name of the secondary developer responsible for the target. This field is for documentation purposes only.
Documentation
Generated Documentation
Click to open the Target Documentation page to generate and download audit documentation, reconciliation reports, and technical documentation.
Process Information tab
Field
Description
Action On
Displays the date Transform processed the selected Target Source.
Record Count
Displays the number of records in the selected source.
Duration
Displays the amount of time Transform took to process the selected Target Source. If the field is empty, the Target Source has not been processed.
NOTE: The duration for sources, targets, and objects is calculated as the sum of the durations of the various tasks that run within said sources, targets, and objects.
Queue
Click to open the Monitor page to monitor the background job processes for the selected source. If a source has no data to process, this icon is disabled.
Import Table
Create Import Table
If checked, Transform automatically generates the import table when importing data from the source. Transform provides the ability to import data from an Excel file, a text file, or another source table in another database on the same server into a source table.
View Import Table
Click to view the import table.
NOTE: This icon is disabled if the user has checked the Create Import Table check box but has not processed the Target Source after doing so. The View Import Table icon will be disabled until the user clicks the Process icon for the Target Source.
Actions
Import Only
Click to only import the selected source and not process source rules or reports.
Source Rules Only
Click to only process rules only for the selected source.
Source Reports Only
Click to only process reports for the selected source.
Was this article helpful?
Sorry about that.
Why wasn't this helpful? (check all that apply)
Thanks for your feedback.
Want to tell us more?
Send an email to our authors to leave your feedback.
Great!
Thanks for your feedback.