JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Oracle Java CAPS Data Integrator User's Guide     Java CAPS Documentation
search filter icon
search icon

Document Information

Designing Data Integrator Projects

About Data Integrator

Extracting, Transforming, Loading: ETL

Oracle Java CAPS Data Integrator Overview

Extracting, Transforming, and Loading: ETL

Oracle Java CAPS Data Integrator Methodology

Oracle Java CAPS Data Integrator Features

Oracle Java CAPS Data Integrator Architecture

Oracle Java CAPS Data Integrator Design-Time Components

Data Integrator Editor

Oracle Java CAPS Data Integrator Project System

Data Integrator Service Engine

ETL Engine

ETL Service Engine

Data Integrator Monitor

Data Integrator Recovery

Creating Oracle Java CAPS Data Integrator Projects

Connecting to Source and Target Databases

Connecting to a JDBC-Compliant Database

Creating and Connecting to Data Mashup Services

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

Viewing and Modifying Table Data

You can view the data contained in any of the source or target tables included in an ETL collaboration. You can also perform some data modification, such as inserting and deleting rows, truncating the table, and copying table data.

To View and Modify Table Data

  1. Open the collaboration you want to view or edit.
  2. Right-click the table in the ETL Collaboration Editor, and select Show Data.
  3. To add a record, do the following:
    1. In the Data Integrator Output panel, click Insert a Record in the toolbar to the left.
    2. On the dialog box that appears, enter values for the fields in the new row.
      image:Figure shows the Enter the Values dialog box.
    3. Click OK.
    4. On the confirmation dialog box, click Yes.
    5. Click OK.
  4. To delete a record, do the following:
    1. In the Data Integrator Output panel, select the row or rows to delete.
    2. Click Delete Selected Records in the toolbar to the left.
    3. On the confirmation dialog box, click OK.
  5. To copy table data to the clipboard, do the following:
    1. In the Data Integrator Output panel, select the data to copy.

      You can select one or more cells or rows.

    2. Right-click on the cell or row and select one of the following options:
      • Copy Cell Value to copy just the selected cell.

      • Copy Row Values to copy the entire row.

      • Copy Row Values With Header to copy the entire row along with the corresponding column or header names.

    3. Paste the information to the desired location, such as a word processing application.
  6. To truncate the displayed table, click Truncate This Table in the left toolbar of the Data Integrator Output panel.