Managing the Scope of Column Changes in Jobs

Problem

You have added columns and you need to determine the scope of these additions. Select one of the following scenarios:

No propagation: Adding column changes to the output of a single transformation in a job
Automatic propagation: Automatically adding column changes to tables in a specified direction
Manual propagation: Manually controlling the addition of column changes in specified paths and directions

Note that you can propagate column changes only in the context of a job. If you add column changes in the properties window for a table from a tree or a folder, the propagate and mapping options that you see on the Mappings tab in a job are not available. In that case, you must remember to map and propagate the column changes when you later use the altered table in a job. Therefore, it is generally more efficient to make and propagate your columns directly in the jobs where you need them.

Solution

You can use an appropriate propagation control in a SAS Data Integration Studio job to enable or disable automatic propagation or to exercise manual control over propagation functions. Perform the following tasks:

Tasks

Managing Automatic Propagation

Automatic propagation sends column changes to tables when process flows are created. If you disable automatic propagation and refrain from using manual propagation, you can propagate column changes on the Mappings tab for a transformation that are restricted to the target tables for that transformation. Automatic propagation controls are explained in the following table.

Automatic Propagation Controls

Level	Control	Set Propagation Direction
Global	Automatically propagate columns in the Automatic Settings group box on the Job Editor tab in the Options window. (Click Options in the Tools menu to display the window.) This option controls automatic propagation of column changes in all new jobs.	Select one of the following directions in the Propagation Direction group box: From beginning to end From end to beginning
Job	Automatically Propagate Job in the drop-down menu that displays when you click Settings in the toolbar on the Diagram tab in the Job Editor window. This option controls automatic propagation of column changes in the currently opened job.	Select one of the following directions in the drop-down menu: From Beginning to End From End to Beginning
Process flow	Propagate Columns in the pop-up menu on the Diagram tab in the Job Editor window. This option controls automatic propagation of column changes in the process flow in a currently opened job.	Select one of the following directions in the pop-up menu: To Beginning To End
Transformation	Include Transformation in Propagation in the drop-down menu that displays when you click Settings in the toolbar on the Mappings tab. This option controls automatic propagation of column changes in the selected transformation.	Not applicable
Transformation	Include Selected Columns in Propagation in the drop-down menu that displays when you click Settings in the toolbar on the Mappings tab to propagate changes to columns that you select in the source or target tables for the selected transformation.	Not applicable

The Mappings tab is available in the following locations:

the Details section in the Job Editor window
the properties windows for any transformation that is included on the Diagram tab of the Job Editor window

The Mappings tab performs the same functions and contains the same items in both locations.

Managing Manual Propagation

Add, delete, or update the columns in your job. Manual propagation controls are explained in the following table.

Manual Propagation Options

Level	Control	Function	Direction
Job	Propagate Job in the toolbar in the Diagram tab in the Job Editor window	Propagates column changes in the job.	Uses the direction set with Settings on the Job Editor toolbar.
Process flow	Propagate Columns in the pop-up menu in the Diagram tab in the Job Editor window	Propagates column changes in the process flow in a specified direction.	Use the following directions: To Beginning To End
Transformation	Propagate from sources to targets in the toolbar in the Mappings tab	Propagates column changes in the process flow from source tables to target tables.	From source tables to target tables.
Transformation	Propagate from targets to sources in the toolbar in the Mappings tab	Propagates column changes in the process flow from target tables to source tables.	From target tables to source tables.
Transformation	Propagate in pop-up menus in the Source table field and the Target table field	Specifies a path and a direction for propagating column changes. See the table that follows for details.
Transformation	Propagate columns in the toolbar on the Mappings tab	Specifies a path and a direction for propagating column changes. See the table that follows for details.

The following table specifies the available path and direction options for the Propagate field and Propagate columns field on the Mappings tab for a transformation.

Propagation Path Options

Path	Direction
For the Propagate option in pop-up menus in the Source table field and the Target table field
To Targets	From Sources From Beginning From End
From Targets	To Sources To Beginning To End
Selected Target Columns	To Sources To Beginning To End
Update Selected Target Columns	To Sources To Beginning To End
For the Propagate columns in the toolbar on the Mappings tab
To Targets	From Sources From Beginning From End
To Sources	From Targets From Beginning From End
From Targets	To Sources To Beginning To End
From Sources	To Targets To Beginning To End
Selected Target Columns	To Sources To Beginning To End
Selected Sources Columns	To Targets To Beginning To End
Update Selected Target Columns	To Sources To Beginning To End
Update Selected Sources Columns	To Targets To Beginning To End