SAS Data Integration Studio P8: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. | 30 Overview of the Main Wizards A Chapter 3 Wizard Description Metadata Export Exports the default metadata repository that is specified in your metadata profile. You can export metadata in Common Warehouse Metamodel CWM format or in formats that are supported by the optional Meta Integration Model Bridges MIMBs from Meta Integration Technology Inc. See Importing and Exporting Metadata on page 98. Metadata Import Imports table metadata in CWM format or in formats that are supported by the optional MIMBs from Meta Integration Technology Inc. You have the option of comparing the imported metadata to existing metadata. You can view any changes in the Differences window and choose which changes to apply. See Importing and Exporting Metadata on page 98. Process Designer Displays the New Job wizard. The New Job wizard enables you to specify one or more tables as the targets outputs of a job. This wizard can also be used to create an empty job into which you can drag and drop tables and transformation templates. See New Job Wizard on page 32. Source Designers Generate metadata for one or more selected tables based on the physical structure of the table s . See Example Using a Source Designer to Register SAS Tables on page 120. Target Designers Two target designer wizards are provided with SAS Data Integration Studio. The Cube Designer adds and maintains a cube a data store that supports Online Analytical Processing OLAP . See Working with OLAP Cubes on page 116. The Target Table Designer generates metadata for a single table that does not yet exist in physical storage such as a table that will be created when a SAS Data Integration Studio job is executed for the first time. Other target designer wizards can be licensed for your site. See Example Using the Target Table Designer to Register SAS Tables on page 140. Transformation Exporter Exports a generated transformation that is registered in your metadata repository. For more information see Exporting a Generated .
