- Book Information
- Chapter 1 Designing Data Integrator Projects
- About Data Integrator
- Extracting, Transforming, Loading: ETL
- Sun Data Integrator Overview
- Sun Data Integrator Architecture
- Data Integrator Recovery
- Creating Sun Data Integrator Projects
- Connecting to Source and Target Databases
- Virtual Database Table Metadata Options
- Virtual Database Column Properties
- Creating a New Data Integrator Project
- Creating an ETL Collaboration Using the Wizard
- Creating a Basic ETL Collaboration
- Creating an Advanced ETL Collaboration
- Creating an ETL Collaboration for a Master Index Staging Database
- Creating a Bulk Loader ETL Collaboration
- ETL Collaboration Overview
- Configuring ETL Collaborations
- Joining Source Tables
- Modifying an Existing Join
- Defining Extraction Conditions and Validations
- Adding Tables to an Existing Collaboration
- Forcing Execution Strategies for Collaborations
- Changing the Database URL for Design Time
- Configuring Source Table Properties
- Configuring Target Table Properties
- Using Pre-Created Temporary Staging Tables
- Viewing Table or Join Data
- Viewing the SQL Code
- Viewing Runtime Output Arguments
- Fine-Tuning the ETL Process
- Grouping Input Data
- Viewing and Modifying Table Data