SAS Data Integration Studio P22:This manual is a companion to the online Help for SAS Data Integration Studio. The Help describes all windows in SAS Data Integration Studio, and it summarizes the main tasks that you can perform with the software. The Help includes examples for all source designer wizards, all target designer wizards, and all transformation templates in the Process Library tree. | 100 Creating Running and Verifying Jobs A Chapter 7 and creates targets in physical storage. After you have entered metadata for sources and targets you are ready to create jobs. Prerequisites It is easier to create a job if metadata for the tables in the job are created first. For details about these tasks see Chapter 8 Registering Data Sources on page 119 and Chapter 9 Registering Data Targets on page 139. Check Out Existing Metadata That Must Be Updated As you work on the current job will you update the metadata for any registered tables If so you must check out the metadata for that table. For example suppose that you want to create a job in which data is extracted from a registered table and then is written to a report. In this case the metadata for the table is not changed so you would not have to check out the metadata. However suppose that you want to create a job that require you to add three new columns to the metadata for a registered table. In that case the metadata for the table is changed so you would need to check out the metadata. The next task is to create and populate the job. Create and Populate the New Job Follow these steps to create and populate a new job. To populate a job you will create a complete process flow diagram from sources through transformations to targets. 1 On the SAS Data Integration Studio desktop select Tools Process Designer from the menu bar. The New Job wizard displays. You can use this wizard to create an empty job into which you can drag and drop tables and transformations. That is the approach that is described here. 2 Enter a name for the job and click Finish. 3 An empty job will open in the Process Designer window. 4 Add metadata for sources targets and transformations as needed. The goal is to create a complete process flow diagram from sources through transformations to targets. Drag and drop transformation templates from the Process Library tree. Drag and drop tables from the Inventory tree or from another tree in .
