SAS(R) Data Integration Studio 4.21: User's Guide
Introduction- General User Tasks
- Getting Started
- Setup for SAS Data Integration Studio
- Security for SAS Data Integration Studio
- Main Tasks for Creating Process Flows
- Starting SAS Data Integration Studio
- Connecting to a SAS Metadata Server
- Working with the Folders Tree
- Selecting a Default SAS Application Server
- Registering SAS Libraries
- Working with User-Defined Formats
- Registering Tables and Cubes
- Specifying Global Options in SAS Data Integration Studio
- Working with Change Management
- Add a Note or Document to a Registered Object
- View the Content of Notes or Documents
- Importing, Exporting, and Copying Metadata
- Metadata Import and Export in SAS Data Integration Studio
- Working with SAS Package Metadata
- Preparing to Import or Export SAS Package Metadata
- Exporting SAS Package Metadata
- Importing SAS Package Metadata
- Copying and Pasting Metadata Objects
- Working with SAS Metadata Bridges
- Usage Notes for Importing or Exporting with a SAS Metadata Bridge
- Preparing to Import or Export with a SAS Metadata Bridge
- Importing New Metadata with a SAS Metadata Bridge
- Importing Updated Metadata with a SAS Metadata Bridge
- Exporting Metadata with a SAS Metadata Bridge
- Working with Tables
- About Tables
- Registering Existing Tables with the Register Tables Wizard
- Registering New Tables with the New Table Wizard
- Viewing or Updating Table Metadata
- Using a Physical Table to Update Table Metadata
- Specifying Options for Tables
- Supporting Case and Special Characters in Table and Column Names
- Maintaining Column Metadata
- Maintaining Keys
- Maintaining Indexes
- Browsing Table Data
- Editing SAS Table Data
- Using the View Data Window to Create a SAS Table
- Specifying Browse and Edit Options for Tables and External Files
- Working with External Files
- About External Files
- Registering a Delimited External File
- Registering a Fixed-Width External File
- Registering an External File with User-Written Code
- Viewing or Updating External File Metadata
- Overriding the Code Generated by the External File Wizards
- Specifying NLS Support for External Files
- Accessing an External File with an FTP Server or an HTTP Server
- Viewing Data in External Files
- Registering a COBOL Data File That Uses a COBOL Copybook
- Using an External File in the Process Flow for a Job
- Creating Jobs
- About Jobs
- Creating an Empty Job
- Creating a Process Flow for a Job
- Creating a Job That Contains Jobs
- Working with Default Temporary Output Tables
- Specifying Options for Jobs
- Documenting Process Flow Diagrams
- Accessing Local and Remote Data
- Viewing or Updating Job Metadata
- Displaying the SAS Code for a Job
- Common Code Generated for a Job
- Managing Jobs
- About Managing Jobs
- Submitting a Job for Immediate Execution
- Meeting Prerequisites for Collecting Job Statistics
- Reviewing a Successful Job
- Diagnosing and Correcting an Unsuccessful Job
- Maintaining Column Mappings
- Managing the Scope of Column Changes in Jobs
- Managing Connections in Job Editor Windows
- Viewing the Code for a Transformation
- Specifying Options for Transformations
- Redirecting Temporary Output Tables
- Pushing Job Code down to a Database
- Restarting Jobs From Checkpoints
- Managing the Status of Jobs and Transformations
- About Status Handling for Jobs and Transformations
- Default Conditions, Actions, and Conditional Action Sets
- Prerequisites for Actions
- Perform Actions Based on the Status of a Job
- Perform Actions Based on the Status of a Transformation
- Macro Variables for Status Handling
- Deploying Jobs
- About Deploying Jobs
- About Deploying Jobs for Scheduling
- Prerequisites for Deploying a Job for Scheduling
- Deploying Jobs for Scheduling
- Redeploying Jobs for Scheduling
- Using Scheduling to Handle Complex Process Flows
- Using Deploy for Scheduling to Execute Jobs on a Remote Host
- About Deploying Jobs as Stored Processes
- Prerequisites for Deploying a Job as a Stored Process
- Deploying Jobs as Stored Processes
- Redeploying Jobs to Stored Processes
- Viewing or Updating Stored Process Metadata
- About Deploying Jobs as Web Services
- Prerequisites for Web Service Jobs
- Requirements for Web Service Jobs
- Creating a Web Service Job
- Deploying a Web Service Job as a Stored Process
- Deploying a Stored Process as a Web Service
- Working with Generated Code
- About Code Generated for Jobs
- Displaying the Code Generated for a Job
- Displaying the Code Generated for a Transformation
- Specifying Options for Jobs
- Specifying Options for a Transformation
- Modifying Configuration Files or SAS Start Commands for Application Servers
- Working with User-Written Code
- About User-Written Code
- Adding User-Written Code to the Precode and Postcode Tab
- Adding a User Written Code Transformation to a Job
- Creating and Using a Generated Transformation
- Maintaining a Generated Transformation
- Editing the Generated Code for a Job or Transformation
- Replacing the Generated Code for a Job or Transformation
- Importing SAS Code
- Optimizing Process Flows
- About Process Flow Optimization
- Managing Process Data
- Managing Columns
- Streamlining Process Flow Components
- Using Simple Debugging Techniques
- Using SAS Logs
- Reviewing Temporary Output Tables
- Additional Performance Optimization Information
- Using Impact Analysis
- About Impact Analysis and Reverse Impact Analysis
- Performing an Impact Analysis
- Performing Impact Analysis on a Generated Transformation
- Performing Reverse Impact Analysis
- Working with Reports
- Working with Transformations
- Working with Loader Transformations
- About Loader Transformations
- About the SPD Server Table Loader Transformation
- Teradata Table Loader Transformation
- About the Table Loader Transformation
- Setting Table Loader Transformation Options
- Selecting a Load Technique in the Table Loader
- Removing Non-Essential Indexes and Constraints during a Load
- Considering a Bulk Load
- Working with SAS Sort Transformations
- About Sort Transformations
- Optimizing Sort Performance
- Creating a Table That Contains the Sorted Contents of a Source
- Working with SQL Join Transformations
- About SQL Join Transformations
- Using the Designer Window
- Reviewing and Modifying Clauses, Joins, and Tables in an SQL Query
- Understanding Automatic Joins
- Selecting the Join Type
- Adding User-Written SQL Code
- Debugging an SQL Query
- Adding a Column to the Target Table
- Adding a Join to an SQL Query on the Designer Tab
- Creating a Simple SQL Query
- Configuring a SELECT Clause
- Adding a CASE Expression
- Creating or Configuring a WHERE Clause
- Adding a GROUP BY Clause and a HAVING Clause
- Adding an ORDER BY Clause
- Adding Subqueries
- Validating or Submitting an SQL Query
- Joining a Table to Itself
- Using Parameters with an SQL Join
- Constructing a SAS Scalable Performance Data Server Star Join
- Optimizing SQL Processing Performance
- Performing General Data Optimization
- Influencing the Join Algorithm
- Setting the Implicit Property for a Join
- Enabling Pass-Through Processing
- Using Properties Window Options to Optimize SQL Processing Performance
- Working with Iterative Jobs and Parallel Processing
- About Iterative Jobs
- Creating and Running an Iterative Job
- Creating a Parameterized Job
- Creating a Control Table
- About Parallel Processing
- Setting Options for Parallel Processing
- Working with Slowly Changing Dimensions
- About Slowly Changing Dimensions
- About Dimension Tables
- About Fact Tables
- Loading a Dimension Table with Type 1 and 2 Updates
- Loading a Fact Table Using Dimension Table Lookup
- Loading a Table and Adding a Surrogate Primary Key
- Tracking Changes in Source Datetime Values
- Closing Out Rows in Datetime Change Tracking
- Working with Change Data Capture
- About the Change Data Capture Transformations
- About CDC Changed Data Tables
- About CDC Control Tables
- Capture Changed Data from Oracle
- Working with Message Queues
- About Message Queues
- Prerequisites for Message Queues
- Selecting Message Queue Transformations
- Processing a WebSphere Queue
- Polling a Websphere Message Queue
- Processing a Microsoft Queue
- Working with SPD Server Cluster Tables
- Appendixes
- Main Windows and Wizards
- Analysis Window
- Checkouts Tree
- Code Editor
- Comparison Results Window
- Connection Profile Window
- Desktop
- Details Pane
- Expression Builder
- Folders Tree
- Inventory Tree
- Job Editor
- Properties Windows
- Reports Window
- Tools-Options Window
- Transformations Tree
- Tree View
- View Data Windows
- Wizards
- Java Code and Methods for Report Plug-ins
- Glossary
Index here
| Product | Release |
|---|---|
| SAS Data Integration Server | 9.2 |
| SAS Data Integration Studio Server Data | 9.2 |
| SAS Enterprise Data Integration Server | |
| SAS Data Integration Studio | 4.21 |
- Type
- Usage and Reference
- Copyright Date
- April 2009
- Last Updated
- 26Jun2009
