Databases Reference
In-Depth Information
Note:
In a process flow, a User-Written Code transformation can have only one
input and one output. If you need additional inputs or outputs, consider adding a
generated transformation, as described in the next section.
For more details about using a User-Written Code transformation in a job, see
“Example: Include a User-Written Code Template in a Job” in the Help for SAS Data
Integration Studio.
Adding a Generated Transformation to the Process Library
If have custom code that you would want to use in more than one place, or if there
are multiple inputs or outputs for your custom code segment, use the Transformation
Generator wizard to create a generated transformation.
To display the Transformation Generator wizard from the SAS Data Integration
Studio desk top, select
Tools
Transformation Generator
from the menu bar. In the
wizard, specify the number of inputs and outputs, any custom options, then attach your
user-written SAS code, just as you would for the User-Written transformation described
in the previous section. The newly created transformation appears in the Process
Library tree, where it is available for use in any SAS Data Integration Studio job.
Drop the generated transformation into the process flow for a job and set any options.
When the job is executed, the user-written code is retrieved and executed as part of the
job. For more information, see “Maintaining Generated Transformations” on page 75.
Search WWH ::
Custom Search