User Guide

11.0
- 10.0

Back Next

Selecting Source Tables and Materialized Views for Unload Processing

On the

Source Tables

tab, select one or more source tables or materialized views from which to unload data and specify the unload method for these tables or materialized views.

Click the

Source Tables

tab.

The following image shows this tab:

Under

Owner

, select a schema owner name in one of the following ways:

Select the schema owner from the list.

Enter the first few letters of the schema owner name. If a matching owner name exists in the source database, the Fast Clone Console completes the name.

The owner name is the same as the schema name.

The

Tables

box lists all of the tables and materialized views with the specified schema owner name. The

Support Direct

column indicates whether the table or materialized view supports the direct path unload method.

To view only the tables and materialized views that support the direct path unload method, click

Show Direct Supported

. To view all of the tables and materialized views in the schema again, click

Show All

To select a subset of source tables or materialized views for unload processing and set the unload method for each one, complete the following steps:

Select the

Unload

check box for each table or materialized view, or click

Select All

and then clear the

Unload

check box for any table or materialized view that you do not want to unload data from.

The

Select None

button clears all selections to exclude all of the tables and materialized views from unload processing.

To use the direct path unload method for a selected table or materialized view, ensure that the

Perform Direct Unload

check box is selected for the table or materialized view.

By default, the Fast Clone Console selects the direct path unload method for all of the source tables and materialized views for which Fast Clone supports the direct path unload method.

To use the conventional path unload method for a selected table or materialized view, clear the

Perform Direct Unload

check box for the table or materialized view.

To clear the

Perform Direct Unload

check box for all of the tables and materialized views, click

Make None Direct

. If you configure Fast Clone to unload data from a remote source database server, click

Make None Direct

to use the conventional path method.

To select all of the tables and materialized views for the specified schema owner for unload processing, complete the following steps:

Select the

Unload data from entire schema for selected owner

option.

In the

Unload type

list, select an option for the unload method to use for the tables and materialized views in the schema. Options are:

Let Informatica Fast Clone decide during unload

. Fast Clone uses the direct path unload method for the tables and materialized views that support this method. Fast Clone uses the conventional path unload method for the tables and materialized views that do not support the direct path unload method.

Perform direct unload for all tables

. Fast Clone uses the direct path unload method for all of the tables and materialized views. Do not use this option if the source schema includes one or more tables or materialized views that do not support the direct path unload method.

Perform conventional unload for all tables (none direct)

. Fast Clone uses the conventional path unload method for all of the tables and materialized views. Use this option if you need to unload data from a remote source database server.

Rename Saved Search

Table of Contents

User Guide

User Guide

Selecting Source Tables and Materialized Views for Unload Processing

Selecting Source Tables and Materialized Views for Unload Processing