Documentation Home
> Designing Data Integrator Projects
Designing Data Integrator Projects
Book Information
ChapterĀ 1 Designing Data Integrator Projects
About Data Integrator
Extracting, Transforming, Loading: ETL
Sun Data Integrator Overview
Extracting, Transforming, and Loading: ETL
Sun Data Integrator Methodology
Sun Data Integrator Features
Sun Data Integrator Architecture
Sun Data Integrator Design-Time Components
Data Integrator Editor
Sun Data Integrator Project System
Data Integrator Service Engine
ETL Engine
ETL Service Engine
Data Integrator Monitor
Data Integrator Recovery
Creating Sun Data Integrator Projects
Connecting to Source and Target Databases
Connecting to a JDBC-Compliant Database
To Connect to a JDBC-Compliant Database
Creating and Connecting to Data Mashup Services
To Create a Mashup Database for Source Data
Virtual Database Table Metadata Options
Virtual Database Column Properties
Creating a New Data Integrator Project
To Create a New Project
Creating an ETL Collaboration Using the Wizard
Creating a Basic ETL Collaboration
To Create a Basic ETL Collaboration
Creating an Advanced ETL Collaboration
To Create an Advanced ETL Collaboration
Creating an ETL Collaboration for a Master Index Staging Database
To Create an ETL Collaboration for a Master Index Staging Database
Creating a Bulk Loader ETL Collaboration
To Create a Bulk Loader ETL Collaboration
ETL Collaboration Overview
Execution Strategies
Direct/Simple Execution Strategy
One Pass Execution Strategy
Staging Execution Strategy
Pipeline Execution Strategy
Whitespace Considerations
Explicit and Implicit Joins
Runtime Properties
Data Validation Conditions
About the ETL Collaboration Editor
Configuring ETL Collaborations
Joining Source Tables
To Join Source Tables
To Join Source Tables During Mapping
Modifying an Existing Join
To Join Source Tables
Defining Extraction Conditions and Validations
To Define Extraction Conditions and Validation.
Adding Tables to an Existing Collaboration
To Add Tables to a Collaboration
Forcing Execution Strategies for Collaborations
To Force Execution Strategies for Collaborations
Changing the Database URL for Design Time
To Change the Database URL for Design Time
Configuring Source Table Properties
To Configure Source Table Properties
Configuring Target Table Properties
To Configure Target Table Properties
Using Pre-Created Temporary Staging Tables
Using Temporary Staging Tables
Viewing Table or Join Data
To View Table or Join Data
Viewing the SQL Code
To View SQL Code
Viewing Runtime Output Arguments
To View Runtime Output Arguments
Fine-Tuning the ETL Process
Filtering Source Data Using Runtime Inputs
To Filter Source Data Using Runtime Inputs
Setting the Batch Size for Joined Tables
To Set the Batch Size for Joined Tables
Using Table Aliases with Multiple Source Table Views
Grouping Input Data
To Group Input Data
Viewing and Modifying Table Data
To View and Modify Table Data
© 2010, Oracle Corporation and/or its affiliates