Flylib.com
List of Figures
Previous page
Table of content
Next page
< Day Day Up >
Chapter 2: Introduction to SAS ETL Studio
Figure 2.1: SAS Intelligence Value Chain
Figure 2.2: Software Architecture for the SAS Intelligence Platform
Display 2.1: Open a Metadata Profile Window
Display 2.2: SAS ETL Studio Desktop
Display 2.3: Process Designer Window
Display 2.4: Source Editor Window
Display 2.5: Options Window
Chapter 3: Designing a Data Warehouse
Figure 3.1: Best Practice Data Warehouse
Chapter 4: Example Data Warehouse
Display 4.1: Total Sales by Employee (mockup)
Display 4.2: The STAFF Table
Display 4.3: The ORGANIZATION Table
Display 4.4: The ORDERS Table
Display 4.5: The ORDER_ITEM Table
Display 4.6: The CUSTOMER Table
Display 4.7: Time and Place Dependencies for Sales
Chapter 6: Task Overview for Users
Display 6.1: Process Flow for a SAS ETL Studio Job
Chapter 7: Specifying the Inputs to Warehouse Data Stores
Display 7.1: Source Designer Selection Window
Display 7.2: Select a SAS Library Window
Display 7.3: Define Tables Window
Display 7.4: Wizard Finish Window
Display 7.5: Project Tree with Metadata Objects for Three Tables
Display 7.6: Source Designer Selection Window
Display 7.7: External File Selection Window
Display 7.8: Import Parameters Window
Display 7.9: Fixed Width Column Definition Window
Display 7.10: Set Column Definition Window
Display 7.11: SAS Destination Window
Display 7.12: Project Tree with Output from the External File Source Designer
Chapter 8: Specifying Warehouse Data Stores
Display 8.1: Target Designer Selection Window
Display 8.2: Name and Description Window
Display 8.3: Import Columns Window
Display 8.4: Target Columns Window
Display 8.5: Physical Storage Window
Display 8.6: Finish Window
Display 8.7: Project Tree with a Metadata Object for a New Table
Chapter 9: Introduction to SAS ETL Studio Jobs
Display 9.1: Simple Process Flow Diagram
Display 9.2: New Job Wizard
Display 9.3: New Job Wizard, Second Window
Display 9.4: Transformation Template for Sort Staff Job
Display 9.5: Process Designer Window
Display 9.6: Source Editor Tab
Display 9.7: Process Library Tree
Display 9.8: SAS Sort Transformation Template
Display 9.9: Job Properties Window
Display 9.10: Table Properties Window
Display 9.11: Transformation Properties Window
Display 9.12: General Information Window, Transformation Generator Wizard
Display 9.13: Contents of Data Set TigersHitting2002
Display 9.14: Example Hitting Statistics Report
Display 9.15: First Window in the Transformation Generator Wizard
Display 9.16: SAS Code Window
Display 9.17: SAS Code Options Window
Display 9.18: Transform Options Window
Display 9.19: Process Library Tree With User-Defined Transformation Template
Chapter 10: Loading Warehouse Data Stores
Display 10.1: The New SQL Join Transformation in the New Job
Display 10.2: Sources and Targets in the Example Job
Display 10.3: Example Job with Publish to Archive
Display 10.4: Target Table Used as the Source for Publish to Archive
Display 10.5: SUM Statement in the Expression Builder
Display 10.6: Mapping Source Columns in the SQL Join Transformation
Display 10.7: SQL Code Configured Automatically
Display 10.8: Configured Target Columns
Display 10.9: Column Mapping in the Loader
Display 10.10: Options in the Publish to Archive Transformation
Display 10.11: Log Tab with Text from the Example Job
Display 10.12: Viewing the Target
Display 10.13: HTML Report Generated by the Example Job
Display 10.14: Transformations Added to the Job
Display 10.15: Data in the STAFF Source Table
Display 10.16: Data in the ORGANIZATION Source Table
Display 10.17: Fully Populated Job
Display 10.18: Configured Columns in ORGANIZATION_DIM
Display 10.19: Configured Target Table ORGANIZATION_DIM
Display 10.20: Change Tracking Columns in the SCD Type 2 Loader
Display 10.21: Business Key Specified in the SCD Type 2 Loader
Display 10.22: Generated Key Definition in the SCD Type 2 Loader
Display 10.23: Mapped Columns in the SCD Type 2 Loader
Display 10.24: Data in ORGANIZATION_DIM
Display 10.25: Example Hitting Report
Display 10.26: Contents of Table: TigersHitting2002
Display 10.27: PrintHittingStatistics Template, Unpopulated
Display 10.28: PrintHittingStatistics Template, Populated
Display 10.29: Options Tab, PrintHittingStatistics Properties Window
Display 10.30: Column Options Tab, PrintHittingStatistics Properties Window
Display 10.31: Log Tab with Text from the Example Job
Chapter 11: Creating Cubes
Display 11.1: Target Designer Selection Window
< Day Day Up >
Previous page
Table of content
Next page
SAS 9.1.3 ETL Studio: Users Guide
ISBN: 1590476352
EAN: 2147483647
Year: 2004
Pages: 127
Authors:
SAS Institute
BUY ON AMAZON
High-Speed Signal Propagation[c] Advanced Black Magic
Derivation of Telegraphers Equations
Impedance in Series with the Return Path
LVDS Signaling
Laying Cables in an Uncooled Attic Space
The Underlying Simulation Engine
The .NET Developers Guide to Directory Services Programming
Searching the Global Catalog
Virtual List View Searches
Collection Class Usage
Useful Shortcuts for Developers
Error 0x8007202F: A constraint violation occurred.
Building Web Applications with UML (2nd Edition)
Role of Process
Influences of Architecture
Activities
Analysis Model Structure
Advanced Client-Side Scripting
Managing Enterprise Systems with the Windows Script Host
File Operations
Registry Operations
Network Administration/WMI
Internet Applications
Exchange Server
Excel Scientific and Engineering Cookbook (Cookbooks (OReilly))
Exploring Functions
Navigating the VBA Editor
Importing Data Using Drag-and-Drop
Detrending a Time Series
Using Excel to Help Solve Problems Formulated Using the Finite Element Method
Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference
Wide Area Network (WAN) Technologies
Address Resolution Protocol (ARP)
Internet Protocol (IP) Basics
Internet Group Management Protocol (IGMP)
User Datagram Protocol
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