Flylib.com
SAS 9.1.3 ETL Studio: Users Guide
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
SAS 9.1.3 ETL Studio: Users Guide
ISBN: 1590476352
EAN: 2147483647
Year: 2004
Pages: 127
Authors:
SAS Institute
BUY ON AMAZON
Crystal Reports 9 on Oracle (Database Professionals)
Oracle Structures
Oracle SQL
Optimizing: The Crystal Reports Side
Optimizing: Reducing Parses
Appendix A Common Issues
Inside Network Security Assessment: Guarding Your IT Infrastructure
Risk Assessment Best Practices
Making Sure You Are Ready to Begin
A Brief History of Security Tools
Security Incident Response Team (SIRT)
Information Request Form
Kanban Made Simple: Demystifying and Applying Toyotas Legendary Manufacturing Process
Introduction to Kanban
Forming Your Kanban Team
Developing a Kanban Design
Improving the Kanban
Appendix C Two-Bin Kanban Systems
Programming Microsoft ASP.NET 3.5
Web Forms Internals
The HTTP Request Context
ASP.NET State Management
Creating New ASP.NET Controls
Design-Time Support for Custom Controls
InDesign Type: Professional Typography with Adobe InDesign CS2
Character Formatting Options
Paragraph Indents and Spacing
Paragraph Indents
Working with Tables
Working with Table Cells
Telecommunications Essentials, Second Edition: The Complete Global Source (2nd Edition)
Satellite
Circuit-Switched Networks
Wireless Impairments
The Handset Revolution
Mobile Gaming
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies