Databases Reference
In-Depth Information
Note: After a transformation is checked in, only an administrator can update it so
that future changes do not adversely affect other users. ￿
Document Any Usage Details for the Transformation
The person who creates a generated transformation should document how it can be
used to get the desired result. SAS Data Integration Studio users would need to know
the following:
￿ Any requirements for inputs and outputs.
For example, the columns in the source table for the PrintHittingStatistics
template are assumed to be similar to the columns that are shown in Display 6.1
on page 76.
￿ Where the template sends its output: to a table, to the Output tab in the Process
Designer window, or elsewhere.
￿ How to specify any values that are required by the template.
For example, to produce the report that is shown in Display 6.2 on page 76, a
title must be specified, a set of columns must be selected from the source, and the
sum of the values in the HR column must be calculated.
Using a Generated Transformation in a Job
See “Example: Using a Generated Transformation in a Job” on page 174.
Importing and Exporting Generated Transformations
You can export a generated transformation to an XML file. The export feature
enables you to create a generated transformation and make it available to SAS Data
Integration Studio users who are using different metadata repositories.
The following sections explain how to export a transformation that is currently
registered in your metadata repository, and how to import a transformation from an
XML file and register it in the current metadata repository.
Exporting a Generated Transformation
Follow these steps to export a generated transformation that is registered in your
metadata repository:
1 Select the generated transformation in the Process Library tree.
2 On the SAS Data Integration Studio desktop, select Tools ￿ Transformation
Export from the menu bar. The Export Transform window displays.
3 Enter a filename for the XML file in the File name text box.
4 Click OK to export the transformation.
Importing a Generated Transformation
Follow these steps to import a generated transformation that has been saved in an
XML file:
1 On the SAS Data Integration Studio desktop, select Tools ￿ Transformation
Import from the menu bar. The Transformation Importer window displays. Build
a list of XML files to import by following these steps one or more times.
2 Click Add . An Import Transform window appears.
 
Search WWH ::




Custom Search