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
Beginning Cryptography with Java
The JCA and the JCE
Symmetric Key Cryptography
Message Digests, MACs, and HMACs
Certificate Revocation and Path Validation
Appendix C Using the Bouncy Castle API for Elliptic Curve
Java How to Program (6th Edition) (How to Program (Deitel))
Case Study: Class GradeBook Using an Array to Store Grades
Self-Review Exercises
Wrap-Up
Terminology
Appendix D. Primitive Types
Visual C# 2005 How to Program (2nd Edition)
Hardware Trends
Decision Making: Equality and Relational Operators
Introduction
Web Resources
E.3. Characters and Glyphs
Microsoft WSH and VBScript Programming for the Absolute Beginner
Overview of the Windows Script Host
VBScript Basics
Conditional Logic
Using Procedures to Organize Scripts
Appendix B Built-In VBScript Functions
InDesign Type: Professional Typography with Adobe InDesign CS2
Type Anatomy
Applying Styles
Editing Styles
Calculating the Height of the Type Area
Anchored Objects
Web Systems Design and Online Consumer Behavior
Chapter VII Objective and Perceived Complexity and Their Impacts on Internet Communication
Chapter VIII Personalization Systems and Their Deployment as Web Site Interface Design Decisions
Chapter XII Web Design and E-Commerce
Chapter XIII Shopping Agent Web Sites: A Comparative Shopping Environment
Chapter XIV Product Catalog and Shopping Cart Effective Design
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