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 Tables
4-1 Data Objects in Warehouse Builder
4-2 Data Types
4-3 Products Dimension Level Details
4-4 Types of Slowly Changing Dimensions
4-5 Dimensionality of the Sales Cube
4-6 Dimension-level Attributes of the Time Dimension
4-7 Time Dimension Level Attributes
5-1 Sources and Targets Supported in Warehouse Builder 10.2
6-1 Source and Target Operators
6-2 Data Flow Operators
6-3 Pre/Post Processing Operators
6-4 Pluggable Mapping Operators
6-5 Operators That You Can Bind to Repository Objects
6-6 Default Sets
6-7 Operators Synchronized with Repository Objects
6-8 Outbound Synchronize Operators
7-1 Example of Literal Value Types
7-2 Global Expression Values
7-3 Types of Conditions for Transitions
7-4 Output and Description of the Extended Transition
8-1 Source-Target Operators Implementation in PL/SQL Mappings
8-2 Data Flow Operator Implementation in PL/SQL Mappings
8-3 Valid Commit Strategies for Operating Modes
8-4 Parameter for the Main Procedure
8-5 Target Table Containing Master Records
8-6 Target Table Containing Detail Records
10-1 Sample Columns Used for Pattern Analysis
10-2 Pattern Analysis Results
10-3 Employees Table
10-4 Employees Table (Child)
10-5 Department Table (Parent)
10-6 Sample Employee Table
10-7 Sample Input to Name and Address Operator
10-8 Sample Output from Name and Address Operator
13-1 Default Dimension Attributes
14-1 Example of Record Type Values
17-1 Transfer Parameters for OMG CWM File Import
17-2 OMG CWM Object Conversion
17-3 OMG CWM Data Type Conversions
18-1 Required Files for Windows
18-2 Required Files for Unix
18-3 SAP Connection Errors
18-4 SQL*Loader Code Generated in ABAP
20-1 Aggregation Results
20-2 Data Type Results
20-3 Domain Results
20-4 Pattern Results
20-5 Unique Key Results
20-6 Functional Dependency Results
20-7 Referential Results
20-8 EMP Table
20-9 DEPT Table
21-1 Sample Records
21-2 Jane Doe Record After Using Match-Merge Operator
21-3
21-4
21-5
21-6
21-7 Conditional Match Rule
21-8 Sample Data
21-9 Match Rule Descriptions
21-10 Algorithms for Conditional Match Rules
21-11 Example Records for Matching
21-12 Name Roles for Person Match Rules
21-13 Options for Person Match Rule
21-14 Options for Firm Rules
21-15 Address Roles
21-16 Options for Address Roles
21-17 Merge Rule Types
21-18 Name and Address Operator Input Roles
21-19 Name Output Components
21-20 Address Output Components
21-21 Error Status Output Components
21-22 Country-Specific Output Components
22-1 Warehouse Builder Specific Activities
22-2 Utility Activities
22-3 Control Activities
22-4 Assign Activity Parameters
22-5 Data Auditor Monitor Activity Parameters
22-6 Email Activity Parameters
22-7 Types of End Activities
22-8 For Loop Activity Parameters
22-9 FTP Activity Parameters for Script in Warehouse Builder
22-10 Substitute Variables for the FTP Activity
22-11 FTP Activity Parameters for Script Outside of Warehouse Builder
22-12 Manual Activity Parameters
22-13 Mapping parameters for PL/SQL
22-14 Mapping parameters for SQL*Loader
22-15 Parameters for the Notification Activity
22-16 SqlPlus Activity Parameters
22-17 SqlPlus Substitution Variables
22-18 User Defined Process Activity Parameters
22-19 Substitute Variables for the User Defined Process Activity
22-20 Wait Activity Parameters
22-21 While Loop Activity Parameters
23-1 Requirements for Replicating Data Between Database Versions
25-1 Loading Types and INTO TABLE Relationship
25-2 All Constraints Target Load Settings
25-3 Target Load Settings for a Selected Constraint
25-4 Default Load Settings for Advanced No Constraints
25-5 Default Load Settings for Advanced All Constraints
25-6 Update Operations
25-7 Sequence Value Options
26-1 Pivoted Data
26-2 Data Pivoted By Row Indicator
26-3 Data in a Crosstab Format
27-1 Parameters of the USERENV function
28-1 Example Repeat Expressions for Schedules
33-1 Import Mode without Matching Names
33-2 Import Mode with Matching Names
34-1 Icon Sets
35-1 Types of Conditions for Transitions
36-1 General Windows Keys
36-2 Tree View Control Keys
36-3 Accelerator Keys Set for Warehouse Builder
36-4 Menu Commands and Access Keys
36-5 Connect Operators Mnemonic Key Assignments
36-6
36-7
36-8
36-9
36-10
36-11
37-1 List of Reserved Words
Scripting on this page enhances content navigation, but does not change the content in any way.