Skip Headers
Oracle® Warehouse Builder User's Guide
10
g
Release 2 (10.2.0.2)
Part Number B28223-05
Home
Book List
Contents
Index
Contact Us
Previous
Next
View PDF
List of Figures
2-1 Warehouse Builder Components
2-2 The Design Center
3-1 Job Details Dialog with Control Center Monitor Preferences
4-1 Data Objects within a Warehouse Module
4-2 Data Object Editor Window
4-3 Available Objects Tab of the Explorer Panel
4-4 Data Object Editor Canvas
4-5 Detail View of a Dimension
4-6 Indicator Bar of the Data Object Editor
4-7 Data Viewer for a Table
4-8 Using the OLAP Catalog to Access Dimensional Objects
4-9 Star Schema Implementation of Products Dimension
4-10 Snowflake Schema Implementation of the Products Dimension
4-11 Implementation of the Sales Cube
4-12 Mapping that Populates a Time Dimension
6-1 Mappings Node on the Project Explorer
6-2 Mapping Editor Canvas
6-3 Indicator Bar on the Mapping Editor
6-4 Default Viewing Options for the Mapping Editor
6-5 Mapping Editor Showing a Table Operator Source
6-6 Add Table Operator Dialog
6-7 Input/Output Tab on the Operator Editor
6-8 Display Set Dialog
6-9 Connected Operators in a Mapping
6-10 Unbound Staging Table without Attributes and Source Table
6-11 Create and Bind Dialog
6-12 Connect Operators Dialog Displaying Attributes to be Mapped
6-13 Connected Attributes
6-14 Match by Name Matching Options
6-15 Target Load Order Dialog
6-16 Property Inspector for a Table Operator
6-17 Synchronizing an Operator
6-18 Synchronizing from a Different Repository Object
6-19 Advanced Synchronizing Options
7-1 Sample Process Flow
7-2 Process Flow Editor
7-3 Indicator Bar on the Process Flow Editor
7-4 Process Flow in the Project Explorer
7-5 The Parameters for a Notification Activity
7-6 Describing an Email Activity Template
7-7 Parameters Page for Email Activity Template
7-8 Explorer Window with an Activity Template selected
7-9 Editing an Activity Template
7-10 Relationship between the scope and the direction in which the data is passed
7-11 Outgoing Transition Conditions
8-1 Mapping Violates Input Requirement for Join Operator
8-2 Valid Mapping Design with Sources Joined Before Match-Merge
8-3 Valid Mapping Design with Staging Table
8-4 Simple Mapping Run in Set Based Mode
8-5 Simple Mapping Run in Row Based Mode
8-6 Simple Mapping Run in Row Based (Target Only) Mode
8-7 Mapping with Multiple Targets Dependent on One Source
8-8 Specifying a Script in the Sqlplus Activity
8-9 Target Load Order Dialog
8-10 Naming Flat File Master and Detail Record Types
8-11 Adding a Sequence Column to the Master and Detail Target Tables
8-12 Completed Mapping from Master-Detail Flat File to Two Target Tables
8-13 Constant Operator Properties
8-14 Completed Mapping from Master-Detail Flat File with a Direct Path Load
8-15 Overview of Partition Exchange Loading
8-16 Mapping with Multiple Sources
8-17 Publish_Sales_Summary Mapping
8-18 Configuration Properties for Table ORDER_SUMMARY
8-19 Automatically Generated "Value Less Than" Setting
9-1 Global Explorer with the Oracle Library
9-2 Transformation Libraries in the Expression Builder
9-3 Creating Custom Transformations in an Oracle Module
9-4 PL/SQL Record Type in a Mapping
10-1 Phases Involved in Providing Quality Information
10-2 Three Types of Data Profiling
10-3 Data Profiling in Warehouse Builder
10-4 Name and Address Operator Used with a Splitter Operator in a Mapping
11-1 Schedules on the Project Explorer
12-1 Partition Tab with Range Partition Selected
12-2 Example Table with Range Partitioning
12-3 Hash by Quantity Partitioning
12-4 Partition Tab with List Partition Selected
12-5 List Partitioning Based on a Single Key Column
12-6 List Partitioning Based on Multiple Key Columns
12-7 Range-List Partitioning with List Defined under Subpartition Template
12-8 Subpartitions Overriding Subpartition Template
12-9 Bitmap Index with Scope Set to Local
12-10 Partition Parameters in the Data Object Editor Configuration Window
12-11 Configuration Properties Dialog
13-1 Level Attributes Page of the Create Dimension Wizard
13-2 Hierarchies Tab of the Data Object Editor
13-3 Type 2 Slowly Changing Dialog
13-4 Type 3 Slowly Changing Dialog
14-1 Connection Information Page in the Create Flat File Modules Wizard
14-2 Record Type Properties Page in the Create Flat File Wizard
14-3 Object Selection Page
14-4 Summary and Import Page Showing File Status
14-5 Name Page for the Flat File Sample Wizard
14-6 Record Organization Page for the Flat File Sample Wizard
14-7 File Format Page for the Flat File Sample Wizard
14-8 File Layout Page for the Flat File Sample Wizard
14-9 Example of a File with Multiple Record Types
14-10 Record Types Page for Delimited Files
14-11 Record Types Page for Fixed Length Files
14-12 Field Lengths Page for the Flat File Sample Wizard
14-13 Field Lengths for Multiple Record Files page
14-14 Field Properties Page for the Flat File Sample Wizard
14-15 File Selection Page for External Table
15-1 Creating and Editing Joins
15-2 Creating Drill Levels
15-3 Item Folder and its Source Object
15-4 Discoverer Administrator Showing Business Intelligence Objects
15-5 Business Presentation Deployed to BI Beans
16-1 Summary and Import Page Showing Reconcile Action
16-2 Import Results Dialog
16-3 Advanced Import Options Dialog for Tables
16-4 The Metadata Location Tab
18-1 Automated Data Retrieval
18-2 Semi Automated Implementation
19-1 Validation Results Dialog
19-2 Validation Navigation Tree
19-3 Generation Results Window
19-4 Script Tab
19-5 Generated Script
20-1 Data Profile Editor
20-2 Data Profile Editor Toolbars
20-3 Profile Objects
20-4 Monitoring Profile Status
20-5 Profile Results
20-6 Data Drill Panel
20-7 Data Rules Panel
20-8 Profile Object Tab
20-9 Aggregation Tabular Results
20-10 Aggregation Graphical Results
20-11 Data Type Results
20-12 Domain Discovery Results
20-13 Unique Key Results
20-14 Functional Dependency
20-15 Graphical Functional Dependency
20-16 Referential Results
20-17 Graphical Referential Results
20-18 Join Results
20-19 Tab Selected for Deriving Data Rule
20-20 Verify and Accept Corrected Tables
20-21 Generated Correction Mapping
20-22 Correction SubMapping
20-23 Data Auditor Execution Results
20-24 Data auditor Monitor Activity in a Process Flow
21-1 Match-Merge Operator in a Mapping
21-2 Householding Data: XREF Group Mapped to Second Match-Merge Operator
22-1 AND Activity in a Process Flow
22-2 End Activities in a Process Flow
22-3 FORK Activity Ensures Parallel Execution
22-4 Absence of FORK Activity Results in Conditional Execution
22-5 Activity View for FTP Activity Using a Script
22-6 SCRIPT Value Editor Using Substitution Variables
22-7 The OR activity in an process flow
22-8 Configuring the Deployed Location
22-9 Parameter added to a Start activity
23-1 Extraction of data from remote databases through multiple remote accesses using database links
23-2 Warehouse Builder Transportable Modules Deployment
23-3 Data Marts in a Data Warehouse
23-4 Viewing the Number of Data files and Total Size
23-5 Schema Node Selected on Define Contents Page
23-6 Import Filter Dialog
23-7 The Job Details Window
24-1 Configuration Properties Dialog For A Mapping
24-2 Configuration Properties Dialog (Flat File Source)
24-3 Activities Configuration Properties Sheet
25-1 Match By Constraint Options for Operators
25-2 Advanced Settings for Match By Constraint
25-3 Construct Object Operator in a Mapping
25-4 Mapping that Loads a Cube
25-5 Data Generator in a Mapping
25-6 Mapping that Sources Data from a Type 3 SCD
25-7 Loading the Products Dimension
25-8 Loading Data Into a Type 2 SCD
25-9 Loading a Type 3 SCD
25-10 External Table Operator in a Mapping
25-11 Expand Operator in a Mapping
25-12 Mapping Editor Showing A Mapping Input Parameter
25-13 Mapping Editor Showing An Output Parameter Operator
25-14 Mapping that Contains a Materialized View Operator
25-15 Mapping Sequence Operator in a Mapping
25-16 Varray Iterator Operator in a Mapping
25-17 Properties Window for Flat File Operator
26-1 Attribute Property Window
26-2 Expression Builder Interface
26-3 Aggregator Operator in a Mapping
26-4 Having Clause Dialog
26-5 Expression Dialog
26-6 Anydata Cast in a Mapping
26-7 Deduplicator in a Mapping
26-8 Expression Operator in a Mapping
26-9 Filter in a Mapping
26-10 Joiner in a Mapping
26-11 Key Lookup in a Mapping
26-12 Input Connections Page of the Key Lookup Operator
26-13 Lookup Page of the Key Lookup Operator
26-14 SALES_DAT
26-15 Pivot Operator in a Mapping
26-16 Pivot Operator Input Connections Tab
26-17 Attributes Copied and Mapped into Pivot In Group
26-18 Pivot Output Attributes Tab
26-19 Pivot Transform Tab
26-20 Set Operation Operator in a Mapping
26-21 Sorter Operator in a Mapping
26-22 Splitter Operator in a Mapping
26-23 Example Mapping with Multiple Targets
26-24 Table Function Operator in a Mapping
26-25 Data Unpivoted from Crosstab Format
26-26 Unpivot Row Locator Page
26-27 Unpivot Output Attributes Page
26-28 Unpivot Transform Page
27-1 Example of OLAP Transformations
28-1 The Schedule Editor
28-2 Selector Dialog for Picking Months in a Year
28-3 Month Clause for January and June
28-4 By Week Number Clause Set to Second To Last Week of the Year
29-1 Main Window in Control Center Manager
31-1 Metadata Dependency Manager
31-2 Lineage Analysis Diagram for ADDRESS_EXT_TABLE
31-3 Impact Analysis Diagram for ADDRESS_EXT_TABLE
31-4 Lineage and Impact Analysis Diagram
31-5 Expanded Icons in an LIA Diagram
32-1 Metadata Change Management Window
32-2 Compare Two Snapshots Dialog Box
32-3 Restore Snapshot Dialog Box
34-1 UDPs for TEST_VIEW
34-2 Structure of the UDO
34-3 Accessing UDO from the Project Explorer
34-4 Editor for UD_JCLASS
34-5 Sample Properties Sheet with User-Defined Properties
34-6 User Defined Icon
34-7 Properties Inspector for EXPENSE_CATEGORIES_CSV
34-8 Icon Set for EXPENSE_CATEGORIES_CSV
34-9 The Select Icon button on the Process Flow Editor
35-1 Execution of an Expert
35-2 Expert Editor
Scripting on this page enhances content navigation, but does not change the content in any way.