Target Sources H

Target Sources V All Tabs

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:

  1. Access Transform.
  2. Click the Targets icon on the Process Area Launch page.
  3. Click the Sources icon for a Target.

Target Sources V All Tabs

Target Sources H

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.