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

The General tab contains the following information about the table. The fields on this tab can be modified.

The Staging parameters tab contains three subgroups of information: Staging, Duplicate Checking, and User Written. In the left panel, 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.

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.

The Precode and Postcode tab contains Precode and Postcode 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.

The Notes tab contains areas where you can annotate the table. Click Help for more information about this 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 will be made into macro variables when the code for this transformation is generated. Click Help for more information about this tab.