SAS 9.1.3 ETL Studio: Users Guide
SAS 9.1.3 ETL Studio: Users Guide
ISBN: 1590476352
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 127
Pages: 127
Authors: SAS Institute
- 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
SAS 9.1.3 ETL Studio: Users Guide
ISBN: 1590476352
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 127
Pages: 127
Authors: SAS Institute