Go to main content
1/12
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Understanding the Migration Process
1.1
About Migration
1.2
About the Migration Utility
1.3
What Is and Is Not Migrated
1.3.1
Objects That Are Migrated
1.3.2
Objects That Are Not Migrated
1.4
Roadmap for Migration
2
Preparing to Migrate
2.1
Migration Requirements
2.2
Migration Utility Run on a Non-64-bit Operating System
2.3
Creating the Migration Utility Configuration File
2.3.1
To Create the Migration Utility Configuration File
2.3.2
Configuration File Parameters
2.3.3
Configuration File Example
3
Using the Migration Utility to Migrate
3.1
Migration Utility Syntax and Parameters
3.2
Migrating an OWB Workspace
3.3
Migrating Specific Objects in an OWB Workspace
3.4
Performing a Test Migration
4
Reviewing Your Migration
4.1
Reviewing Log and Report Files
4.1.1
Reviewing the Migration Utility Log File
4.1.2
Reviewing the Migration Utility Exclusion Report
4.2
Verifying Your Migration
A
Message Reference
B
Reference to Migration Details
B.1
OWB Repositories
B.1.1
OWB Workspace to ODI Work Repository
B.1.2
OWB Platform to ODI Technology
B.1.2.1
Data Type Mapping for OWB GENERIC Platform to ODI Generic SQL Technology
B.1.2.2
Data Type Mapping for OWB ORACLE Platform to ODI Oracle Technology
B.1.2.3
Data Type Mapping for OWB DB2UDB Platform to ODI IBM DB2 UDB Technology
B.1.2.4
Data Type Mapping for OWB SQLSERVER Platform to ODI Microsoft SQL Server Technology
B.1.2.5
Data Type Mapping for OWB FILE Platform to ODI File Technology
B.1.2.6
Data Type Mapping for OWB SAP Platform to ODI SAP ABAP Technology
B.1.3
OWB Location to ODI Data Server
B.1.3.1
Location Name to Data Server Name
B.1.3.2
Location Properties to Data Server Properties
B.1.3.3
Specific Location
B.1.4
OWB Modules to ODI Models
B.1.4.1
Module Name to Model Name
B.1.4.2
Module Properties to Model Properties
B.1.4.3
Additional Migration of OWB Modules to ODI Folders
B.1.4.4
Physical Schema and Logical Schema
B.1.5
OWB Projects to ODI Projects
B.1.6
OWB Folders to ODI Folders
B.2
OWB Data Objects
B.2.1
OWB Table to ODI Datastore
B.2.2
OWB View to ODI Datastore
B.2.3
OWB Materialized View to ODI Datastore
B.2.4
OWB External Table to ODI Datastore
B.2.5
OWB Flat File to ODI Datastore
B.2.6
OWB Sequence to ODI Sequence
B.2.7
OWB Dimensions Under Database Module to ODI Dimension Model
B.2.8
Property Migration Mapping Tables
B.2.9
OWB Dimensions to ODI Dimensions
B.2.10
OWB Cubes to ODI Cubes
B.3
OWB Mappings
B.3.1
OWB Mapping Properties
B.3.1.1
OWB Mapping Logical Properties
B.3.1.2
OWB Mapping Physical Properties
B.3.1.3
PLSQL Physical Properties
B.3.1.3.1
Chunking Options
B.3.1.3.2
Runtime Parameters
B.3.1.3.3
Code Generation Options
B.3.1.4
SQL*LOADER Physical Properties
B.3.1.4.1
SQL Loader Settings
B.3.1.4.2
Runtime Parameters
B.3.1.4.3
SQL Loader Data Files
B.3.1.5
ABAP Mapping Physical Properties
B.3.1.5.1
Runtime Parameters
B.3.1.5.2
SQL Loader Settings
B.3.1.6
SQLPLUS Mapping Physical Properties
B.3.1.6.1
SQL*Plus Settings
B.3.1.6.2
Runtime Parameters
B.3.1.7
Code Template Mappings Physical Properties
B.3.1.7.1
Chunking Options
B.3.1.7.2
Code Generation Options
B.3.1.7.3
Runtime Parameters
B.3.1.7.4
SCD Updates
B.3.2
Multiple Target Mapping Migration
B.3.2.1
Target Load Order
B.3.2.2
Multiple Target Insert (MTI)
B.3.3
Mapping Operator
B.3.4
Mapping Attribute
B.3.4.1
General Properties
B.3.4.2
Data Type Information
B.4
OWB Pluggable Mappings
B.4.1
Pluggable Mapping Folder
B.4.2
Properties of Pluggable Mapping
B.4.3
Input Signature and Output Signature
B.4.4
Join Operator in Pluggable Mapping
C
Migration Details for Operators
C.1
Common Properties
C.2
Aggregate Operator
C.2.1
Logical Properties of the Aggregate Operator
C.2.2
Physical Properties of the Aggregate Operator
C.2.3
Attribute Groups and Attributes of the Aggregate Operator
C.3
Cube Operator
C.4
Deduplicator Operator
C.4.1
Properties of the Deduplicator Operator
C.4.2
Attribute Groups and Attributes of the Deduplicator Operator
C.5
Dimension Operator
C.6
Expression Operator
C.6.1
Properties of the Expression Operator
C.6.2
Attribute Groups and Attributes of the Expression Operator
C.7
External Table Operator
C.7.1
Logical Properties of the External Table Operator
C.7.1.1
General Properties
C.7.1.2
Chunking
C.7.1.3
Error Table
C.7.1.4
SCD Updates
C.7.1.5
Temp Stage Table
C.7.2
Physical Properties of the External Table Operator
C.7.2.1
General Properties
C.7.2.2
Hints
C.7.2.3
Partition Exchange Loading
C.7.2.4
Constraint Management
C.7.3
Migrating the External Table Operator
C.8
Flat File Operator
C.8.1
Logical Properties of the Flat File Operator
C.8.2
Logical Properties of the Map Attribute Group of the Flat File Operator
C.8.3
Logical Properties of the Map Attribute of the Flat File Operator
C.9
Join Operator
C.9.1
Properties of the Join Operator
C.9.1.1
ANSI SQL syntax
C.9.1.2
Join Condition
C.9.1.3
Join Input Role
C.9.2
Migrating an ANSI Join Operator
C.9.2.1
Scenario 1: Two Input Groups with Standard Join
C.9.2.2
Scenario 2: Two Input Groups with Outer Join Using (+) Style
C.9.2.3
Scenario 3: Two Input Groups with Outer Join Using Join Input Role
C.9.2.4
Scenario 4: Two Input Groups with both (+) Style and Join Input Role
C.9.2.5
Scenario 5: Multiple Input Groups
C.9.3
Migrating a Non-ANSI Join Operator
C.9.4
Migrating a Self Join
C.10
Lookup Operator
C.11
Lookup Properties Migration
C.12
Mapping Input Parameter Operator
C.12.1
Properties of the Attributes of the Mapping Input Parameter Operator
C.12.2
Migration Logic
C.12.3
How the Default Value Is Used
C.13
Materialized View Operator
C.13.1
Logical Properties of the Materialized View Operator
C.13.1.1
General Properties
C.13.1.2
Chunking
C.13.1.3
Conditional Loading
C.13.1.4
Data Rules
C.13.1.5
Error Table
C.13.1.6
SCD Updates
C.13.1.7
Temp Stage Table
C.13.2
Physical Properties of the Materialized View Operator
C.13.3
Logical Properties of the Attributes of the Materialized View Operator
C.13.4
Migrating an Unbound Materialized View Operator
C.14
Pivot Operator
C.14.1
Properties of the Pivot Operator
C.14.1.1
General Properties
C.14.1.2
Row Locator
C.14.1.3
Pivot Transform
C.14.2
Map Attribute Group and Map Attribute
C.15
Pluggable Mapping Operator
C.15.1
Properties of the Pluggable Mapping Operator
C.15.2
Attribute Groups and Attributes of the Pluggable Mapping Operator
C.15.3
Migrating an Unbound Pluggable Mapping Operator
C.16
Post-Mapping Operator
C.17
Pre-Mapping Operator
C.18
Sequence Operator
C.19
Set Operator
C.19.1
Properties of the Set Operator
C.19.1.1
Set Operation
C.19.2
Attribute Groups and Attributes of the Set Operator
C.20
Sorter Operator
C.20.1
Logical Properties of the Sorter Operator
C.20.2
Physical Properties of the Sorter Operator
C.21
Splitter Operator
C.21.1
Properties of the Splitter Operator
C.21.1.1
Split Condition
C.21.2
Attribute Groups and Attributes of the Splitter Operator
C.22
Subquery Filter Operator
C.22.1
Properties of the Subquery Filter Operator
C.22.1.1
Name and Description
C.22.1.2
Subquery Filter Condition
C.22.1.3
Subquery Filter Input Role
C.22.2
Map Attribute Groups
C.22.3
Attributes
C.22.3.1
Expression for DRIVER_INPUT Connector Point
C.22.3.2
Expression for SUBQUERY_FILTER_INPUT Connector Point
C.23
Table Operator
C.23.1
Logical Properties of the Table Operator
C.23.1.1
General Properties
C.23.1.2
Change Data Capture
C.23.1.3
Chunking
C.23.1.4
Conditional Loading
C.23.1.5
Control CT
C.23.1.6
Data Rules
C.23.1.7
Error Table
C.23.1.8
SCD Updates
C.23.1.9
Temp Stage Table
C.23.1.10
Partition DML
C.23.2
Physical Properties of the Table Operator
C.23.2.1
General Physical Properties
C.23.2.2
Hints
C.23.2.3
Partition Exchange Loading
C.23.3
Logical Properties of the Attributes of the Table Operator
C.23.3.1
Loading Properties
C.23.3.2
Code Template Metadata Tags
C.23.4
Migrating an Unbound Table Operator
C.24
Table Function Operator
C.24.1
Logical Properties of the Table Function Operator
C.24.2
Logical Properties of the Map Attribute Group of the Table Function Operator
C.24.3
Logical Properties of the Map Attribute of the Table Function Operator
C.24.4
Migrating the Table Function Operator
C.24.4.1
Scenario 1: Table Function operator acts as source, no input map attribute group, only return group (output attribute group).
C.24.4.2
Scenario 2: Table Function Operator has one input attribute group and one output attribute group, data type of input attributes is scalar
C.24.4.3
Scenario 3: Table Function operator has one input attribute group and one output attribute group, some data types of input attributes are REF_CURSOR
C.25
Transformation Function Operator
C.25.1
Properties of the Transformation Function Operator
C.25.2
Logical Properties of the Transformation Function Operator
C.25.3
Physical Properties of the Transformation Function Operator
C.25.4
Properties of the Map Attribute Group of the Transformation Function Operator
C.25.5
Properties of the Map Attribute of the Transformation Function Operator
C.26
Unpivot Operator
C.26.1
Properties of the Unpivot Operator
C.26.1.1
General Properties
C.26.1.2
Row Locator
C.26.2
Map Attribute Group and Map Attribute
C.27
View Operator
C.27.1
Logical Properties of the View Operator
C.27.1.1
General Properties
C.27.1.2
Change Data Capture
C.27.1.3
Chunking
C.27.1.4
Conditional Loading
C.27.1.5
Data Rules
C.27.1.6
Error Table
C.27.1.7
SCD Updates
C.27.1.8
Temp Stage Table
C.27.2
Physical Properties of the View Operator
C.27.3
Logical Properties of the Attributes of the View Operator
C.27.4
Migrating an Unbound View Operator
D
Special Migration Cases
D.1
Tables with Multiple Primary Keys
D.2
Special Cases for Mappings
D.2.1
Two Operators Connected to Same Downstream Operator
D.2.2
Multiple Operators Connected From and To Same Operator
D.2.3
Lookup Operator Has a Constant as Input
D.2.4
Lookup Operators Have No Driver Table (Mapping Is Invalid)
D.2.5
Multiple Operators Connected to Same Operator, Some with No Upstream Source
D.2.6
Multiple Operators Connected to Same Operator, All with Different Upstream Operator
D.2.7
Pluggable Mapping Operator with only Constant as Input
E
Known Issues and Solutions
E.1
Known Issues and Solutions
Scripting on this page enhances content navigation, but does not change the content in any way.