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
FileMaker Pro 8: The Missing Manual
An Very Quick Database Tour
Advanced Find Mode
Layout Mode
Your First Script
Disable Script Steps
MySQL Cookbook
Converting Between Dates and Days
Calculating One Date from Another by Substring Replacement
Displaying One Set of Values While Sorting by Another
Finding Values Associated with Minimum and Maximum Values
Appendix B. JSP and Tomcat Primer
Pocket Guide to the National Electrical Code(R), 2005 Edition (8th Edition)
Article 215 Feeders
Article 326 Integrated Gas Spacer Cable Type IGS
Article 503 Class III Locations
Tables 11(A) and 11(B)
Example No. D4(b) Optional Calculation for Multifamily Dwelling
Cisco ASA: All-in-One Firewall, IPS, and VPN Adaptive Security Appliance
RIP
Application Inspection
File Transfer Protocol
Deployment Scenarios
Deployment Scenarios
AutoCAD 2005 and AutoCAD LT 2005. No Experience Required
Gaining Drawing Strategies: Part 1
Gaining Drawing Strategies: Part 2
Working with Hatches and Fills
Controlling Text in a Drawing
Printing an AutoCAD Drawing
Cultural Imperative: Global Trends in the 21st Century
Culture and Religion
Cross-Century Worldviews
Cognitive Processes
Americanization versus Asianization
Appendix A Cultural Categorization Characteristics
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