Go to main content
1/13
Contents
List of Examples
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Understanding the Migration Process
About Migration
About the Migration Utility
What Is and Is Not Migrated
Objects That Are Migrated
Objects That Are Not Migrated
Roadmap for Migrating
2
Preparing to Migrate
Migration Requirements
Migration Utility Run on a Non-64-bit Operating System
Creating the Migration Utility Configuration File
To Create the Migration Utility Configuration File
Configuration File Parameters
Configuration File Example
3
Using the Migration Utility to Migrate
Migration Utility Syntax and Parameters
Migrating an OWB Workspace
Migrating Specific Objects in an OWB Workspace
Performing a Test Migration
4
Reviewing Your Migration
Reviewing Log and Report Files
Reviewing the Migration Utility Log File
Reviewing the Migration Utility Exclusion Report
Verifying Your Migration
A
Message Reference
B
Reference to Migration Details
OWB Repositories
OWB Workspace to ODI Work Repository
OWB Platform to ODI Technology
Data Type Mapping for OWB GENERIC Platform to ODI Generic SQL Technology
Data Type Mapping for OWB ORACLE Platform to ODI Oracle Technology
Data Type Mapping for OWB DB2UDB Platform to ODI IBM DB2 UDB Technology
Data Type Mapping for OWB SQLSERVER Platform to ODI Microsoft SQL Server Technology
Data Type Mapping for OWB FILE Platform to ODI File Technology
Data Type Mapping for OWB SAP Platform to ODI SAP ABAP Technology
OWB Location to ODI Data Server
Location Name to Data Server Name
Location Properties to Data Server Properties
Specific Location
OWB Modules to ODI Models
Module Name to Model Name
Module Properties to Model Properties
Additional Migration of OWB Modules to ODI Folders
Physical Schema and Logical Schema
OWB Projects to ODI Projects
OWB Folders to ODI Folders
OWB Data Objects
OWB Table to ODI Datastore
OWB View to ODI Datastore
OWB Materialized View to ODI Datastore
OWB External Table to ODI Datastore
OWB Flat File to ODI Datastore
OWB Sequence to ODI Sequence
Property Migration Mapping Tables
OWB Mappings
OWB Mapping Properties
OWB Mapping Logical Properties
OWB Mapping Physical Properties
PLSQL Physical Properties
SQL*LOADER Physical Properties
ABAP Mapping Physical Properties
SQLPLUS Mapping Physical Properties
Code Template Mappings Physical Properties
Multiple Target Mapping Migration
Target Load Order
Multiple Target Insert (MTI)
Mapping Operator
Mapping Attribute
General Properties
Data Type Information
OWB Pluggable Mappings
Pluggable Mapping Folder
Properties of Pluggable Mapping
Input Signature and Output Signature
Join Operator in Pluggable Mapping
C
Migration Details for Operators
Common Properties
Aggregate Operator
Logical Properties of the Aggregate Operator
Physical Properties of the Aggregate Operator
Attribute Groups and Attributes of the Aggregate Operator
Deduplicator Operator
Properties of the Deduplicator Operator
Attribute Groups and Attributes of the Deduplicator Operator
Expression Operator
Properties of the Expression Operator
Attribute Groups and Attributes of the Expression Operator
External Table Operator
Logical Properties of the External Table Operator
General Properties
Chunking
Error Table
SCD Updates
Temp Stage Table
Physical Properties of the External Table Operator
General Properties
Hints
Partition Exchange Loading
Constraint Management
Migrating the External Table Operator
Flat File Operator
Logical Properties of the Flat File Operator
Logical Properties of the Map Attribute Group of the Flat File Operator
Logical Properties of the Map Attribute of the Flat File Operator
Join Operator
Properties of the Join Operator
ANSI SQL syntax
Join Condition
Join Input Role
Migrating an ANSI Join Operator
Scenario 1: Two Input Groups with Standard Join
Scenario 2: Two Input Groups with Outer Join Using (+) Style
Scenario 3: Two Input Groups with Outer Join Using Join Input Role
Scenario 4: Two Input Groups with both (+) Style and Join Input Role
Scenario 5: Multiple Input Groups
Migrating a Non-ANSI Join Operator
Migrating a Self Join
Lookup Operator
Lookup Properties Migration
Mapping Input Parameter Operator
Properties of the Attributes of the Mapping Input Parameter Operator
Migration Logic
How the Default Value Is Used
Materialized View Operator
Logical Properties of the Materialized View Operator
General Properties
Chunking
Conditional Loading
Data Rules
Error Table
SCD Updates
Temp Stage Table
Physical Properties of the Materialized View Operator
Logical Properties of the Attributes of the Materialized View Operator
Migrating an Unbound Materialized View Operator
Pivot Operator
Properties of the Pivot Operator
General Properties
Row Locator
Pivot Transform
Map Attribute Group and Map Attribute
Pluggable Mapping Operator
Properties of the Pluggable Mapping Operator
Attribute Groups and Attributes of the Pluggable Mapping Operator
Migrating an Unbound Pluggable Mapping Operator
Post-Mapping Operator
Pre-Mapping Operator
Sequence Operator
Set Operator
Properties of the Set Operator
Set Operation
Attribute Groups and Attributes of the Set Operator
Sorter Operator
Logical Properties of the Sorter Operator
Physical Properties of the Sorter Operator
Splitter Operator
Properties of the Splitter Operator
Split Condition
Attribute Groups and Attributes of the Splitter Operator
Subquery Filter Operator
Properties of the Subquery Filter Operator
Name and Description
Subquery Filter Condition
Subquery Filter Input Role
Map Attribute Groups
Attributes
Expression for DRIVER_INPUT Connector Point
Expression for SUBQUERY_FILTER_INPUT Connector Point
Table Operator
Logical Properties of the Table Operator
General Properties
Change Data Capture
Chunking
Conditional Loading
Control CT
Data Rules
Error Table
SCD Updates
Temp Stage Table
Partition DML
Physical Properties of the Table Operator
General Physical Properties
Hints
Partition Exchange Loading
Logical Properties of the Attributes of the Table Operator
Loading Properties
Code Template Metadata Tags
Migrating an Unbound Table Operator
Table Function Operator
Logical Properties of the Table Function Operator
Logical Properties of the Map Attribute Group of the Table Function Operator
Logical Properties of the Map Attribute of the Table Function Operator
Migrating the Table Function Operator
Scenario 1: Table Function operator acts as source, no input map attribute group, only return group (output attribute group).
Scenario 2: Table Function Operator has one input attribute group and one output attribute group, data type of input attributes is scalar
Scenario 3: Table Function operator has one input attribute group and one output attribute group, some data types of input attributes are REF_CURSOR
Transformation Function Operator
Properties of the Transformation Function Operator
Logical Properties of the Transformation Function Operator
Physical Properties of the Transformation Function Operator
Properties of the Map Attribute Group of the Transformation Function Operator
Properties of the Map Attribute of the Transformation Function Operator
Unpivot Operator
Properties of the Unpivot Operator
General Properties
Row Locator
Map Attribute Group and Map Attribute
View Operator
Logical Properties of the View Operator
General Properties
Change Data Capture
Chunking
Conditional Loading
Data Rules
Error Table
SCD Updates
Temp Stage Table
Physical Properties of the View Operator
Logical Properties of the Attributes of the View Operator
Migrating an Unbound View Operator
D
Special Migration Cases
Tables with Multiple Primary Keys
Special Cases for Mappings
Two Operators Connected to Same Downstream Operator
Multiple Operators Connected From and To Same Operator
Lookup Operator Has a Constant as Input
Lookup Operators Have No Driver Table (Mapping Is Invalid)
Multiple Operators Connected to Same Operator, Some with No Upstream Source
Multiple Operators Connected to Same Operator, All with Different Upstream Operator
Scripting on this page enhances content navigation, but does not change the content in any way.