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
Certified Ethical Hacker Exam Prep
Key Terms
The Architecture of Windows Computers
Buffer Overflows, Viruses, and Worms
Physical Security
Limited Warranty and Disclaimer
Strategies for Information Technology Governance
An Emerging Strategy for E-Business IT Governance
A View on Knowledge Management: Utilizing a Balanced Scorecard Methodology for Analyzing Knowledge Metrics
Governing Information Technology Through COBIT
Governance in IT Outsourcing Partnerships
Governance Structures for IT in the Health Care Industry
Data Structures and Algorithms in Java
The Stack Interface
Projects
Projects
Binary Search Trees
Vocabulary
Ruby Cookbook (Cookbooks (OReilly))
Hiding Setup and Cleanup in a Block Method
Writing an Inherited Class
Extending Specific Objects with Modules
A Real-World HTTP Client
Finding the Cost to Ship Packages via UPS or FedEx
Cisco ASA: All-in-One Firewall, IPS, and VPN Adaptive Security Appliance
Configuring Accounting
RSH
Summary
Configuring Quality of Service
Troubleshooting PKI
HTI+ Home Technology Integrator & CEDIA Installer I All-In-One Exam Guide
Computer Network Basics
Troubleshooting a Home Network
Troubleshooting Video Systems
Designing and Installing a Home Telephone System
User Interfaces
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