What Are the Properties of the User-Written Staging Transformation?

General Tab

The General tab contains the following information about the table. The fields on this tab can be modified.
Name
identifies the name of the user-written staging transformation that you are specifying.
Description
describes the user-written staging transformation that you are specifying.

Staging Parameters Tab

The Staging parameters tab contains three subgroups of information: Staging, Duplicate Checking, and User-Written. In the left panel of this tab, you can select the subgroup whose properties you want to specify. For information about these properties, see Step 8 of the Create a User-Written Staging Transformation topic.

Code Tab

The Code tab can display and manage the code that is generated for the User-Written Staging transformation. Click Help for more information about this tab.

Precode and Postcode Tab

The Precode and Postcode tab contains check boxes that enable you to specify that user-written code should be inserted at the beginning or end of the current job or transformation. Click Help for more information about this tab.

Notes Tab

The Notes tab contains areas where you can annotate the table. Click Help for more information about this tab.

Extended Attributes Tab

The Extended Attributes tab contains custom properties that are not part of the standard metadata for the transformation. All extended attributes that are added to this tab are made into macro variables when the code for this transformation is generated. Click Help for more information about this tab.