Flylib.com
Books
Software
Computers & Technology
Home Computing
Business & Culture
Programming
Software
Web Development
Certification
Networking
Security & Encryption
Computer Science
Operating Systems
Microsoft
Hardware
Databases
Graphic Design
Apple
Digital Music
Digital Photography & Video
Games & Strategy Guides
Project Management
Mobile & Wireless Computing
Education & Reference
Encyclopedias
Test Preparation
Studying & Workbooks
Schools & Teaching
Writing, Research & Publishing Guides
Foreign Language Study & Reference
Atlases & Maps
Dictionaries & Thesauruses
Words, Language & Grammar
College & University
Trivia & Fun Facts
Consumer Guides
Business & Investing
Industries & Professions
Management & Leadership
Organizational Behavior
Personal Finance
Small Business & Entrepreneurship
Popular Economics
Marketing & Sales
Finance
Skills
Business Life
Economics
Job Hunting & Careers
Biography & History
Reference
International
Real Estate
Investing
Women & Business
Science & Math
Mathematics
Technology
Reference
Earth Sciences
Physics
Biological Sciences
Behavioral Sciences
Nature & Ecology
Astronomy & Space Science
History & Philosophy
Experiments, Instruments & Measurement
Agricultural Sciences
Category list
Computers & Technology
Programming
Languages & Tools
Software
Category list
Education & Reference
SAS 9.1.3 ETL Studio: Users Guide - page 1
Buy on amazon.com >>
N
<< Previous book
Next page >>
1
2
Table of Contents
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
1
2
Buy on amazon.com >>
N
<< Previous book
Next page >>