Maintaining Jobs

Example: Adding a Data Transfer Process to a Process Flow

A Data Transfer process is a metadata record used to generate or retrieve user-written code that moves data from one host to another. For example, a Data Transfer process is required when the output table and its input source reside on different hosts.

Note: The following explanation describes the metadata and methods used to achieve the desired results. It is assumed that the appropriate Data Warehouse Environment, Data Warehouse, Subject, data stores, Job, and Process Flow exist and that the output table and its input source reside on different hosts. [cautionend]

Adding a Data Transfer Process

In the SAS/Warehouse Administrator Explorer, position the cursor on the data store for which you want to add a Data Transfer process to its Process Flow, for example Customer. Click the right mouse button, and select Process. The software opens the Process Editor with the Process Flow displayed.

[untitled graphic]

To add a Data Transfer, in the Process Flow, right-click the Process Flow arrow either below the output table or above the input source, as appropriate, which for this example is the arrow below the output table. Then select Add Data Transfer

[untitled graphic]

To update the default metadata for the Data Transfer, position the cursor on the Data Transfer icon, click the right mouse button, and select Properties. The Data Transfer Process Attributes window displays.

[untitled graphic]

For an explanation about defining the Data Transfer properties, see Example: Defining Data Transfer Process Properties to Move Data from Remote Host to Local Host.

Top of Page