---

SAS 9.1.3 ETL Studio: Users Guide

ISBN: 1590476352
EAN: 2147483647

Year: 2004
Pages: 127

Authors: SAS Institute

BUY ON AMAZON

• Table of Contents
• SAS 9.1.3 ETL Studio-User s Guide
• What s New
• Details
• Your Turn
• Part 1: Introduction
• Chapter 1: Using This Manual
• Intended Audience
• Quick Start with SAS ETL Studio
• SAS ETL Studio Online Help
• Chapter 2: Introduction to SAS ETL Studio
• The SAS Intelligence Value Chain
• The SAS Intelligence Platform
• Features
• Windows
• Wizards
• Usage Notes
• Part 2: Planning, Installation, and Setup
• Chapter 3: Designing a Data Warehouse
• Data Warehousing with SAS ETL Studio
• Planning a Data Warehouse
• Planning Security for a Data Warehouse
• Chapter 4: Example Data Warehouse
• Asking the Right Questions
• Which Sales Person Is Making the Most Sales?
• What Are the Time and Place Dependencies of Product Sales?
• The Next Step
• Chapter 5: Setup Tasks for Administrators
• Review Project Plans
• Install SAS ETL Studio and Related Software
• Start SAS Management Console
• Create a Metadata Profile and a Foundation Repository
• Enter Metadata for Users, Administrators, and Groups
• Create a Project Repository for Each User
• Enter Metadata for Servers
• Enter Metadata for Libraries
• Supporting Case and Special Characters in Table and Column Names
• Prerequisites for SAS Data Quality
• Prerequisites for Metadata Import and Export
• Additional Information about Administrative Tasks
• Part 3: Using SAS ETL Studio
• Chapter 6: Task Overview for Users
• Main Task Flow for Users
• Specifying Metadata for Sources and Targets
• Using Source Designers
• Using Target Designers
• Working with Change Management
• Specifying Metadata for DBMS Tables with Keys
• Viewing the Data in a Table
• Viewing the Metadata for a Table
• Updating the Metadata for a Table
• Setting Name Options for Individual Tables
• Additional Information about User Tasks
• Chapter 7: Specifying the Inputs to Warehouse Data Stores
• Example: Using a Source Designer to Enter Metadata for SAS Tables
• Example: Extracting Information from a Flat File
• Next Tasks
• Chapter 8: Specifying Warehouse Data Stores
• Example: Using the Target Table Designer to Enter Metadata for a SAS Table
• Next Tasks
• Chapter 9: Introduction to SAS ETL Studio Jobs
• Main Windows for Jobs
• General Tasks for Jobs
• Example: Creating a SAS Code Transformation Template
• General Tasks for SAS Code Transformation Templates
• Additional Information about Jobs
• Chapter 10: Loading Warehouse Data Stores
• Example: Creating a Job That Joins Two Tables and Generates a Report
• Example: Using Slowly Changing Dimensions
• Example: Using a SAS Code Transformation Template in a Job
• Chapter 11: Creating Cubes
• General Tasks for Cubes
• Example: Building a Cube from a Star Schema
• Example: Using the Source Editor to Submit User-Written Code for a Cube
• Additional Information about Cubes
• Part 4: Appendixes
• Appendix 1: Usage Notes
• Usage Notes for Source Designers and Target Table Designers
• Appendix 2: Building Java Plug-ins for SAS ETL Studio
• Shortcut Plug-ins
• Installing a Shortcut Plug-in
• Example: Building a Source Designer Plug-in
• Appendix 3: Recommended Reading
• Glossary
• B
• C
• D-E
• F
• G-H
• I
• J-K
• L
• M-N
• O
• P
• Q
• R
• S
• T
• U-Z
• Index
• Index_B
• Index_C
• Index_D
• Index_E
• Index_F
• Index_G
• Index_H
• Index_I
• Index_J
• Index_K
• Index_L
• Index_M
• Index_N
• Index_O
• Index_P-Q
• Index_R
• Index_S
• Index_T
• Index_U
• Index_V
• Index_W
• Index_X-Y
• Index_Z
• List of Figures
• List of Tables