Creating a Quick Copy

How to:

The Quick Copy option generates a simple Data Flow without using the Data Flow designer. For the selected tables, all selected rows and columns are copied to new tables.

Although no transformations or where conditions are generated, the Data Flow can be opened as such from the Data Management Console, and additional criteria can be added. Columns identified as key columns in the source are created as key columns in the target.

Procedure: How to Create a Quick Copy for a Single Table

  1. Right-click a folder, point to Metadata, then click Edit.
  2. Right-click a synonym name and click Quick Copy.

    The Quick Copy dialog box opens. The following options are available:

    Load Option
    • New/Replace. Any existing metadata or data is replaced.
    • Append Existing Data (Keep Metadata). The source data is appended to the target.
    Adapter

    Use the drop-down menu to select a database configured as an adapter.

    Connection

    Use the drop-down menu to select a connection for the selected adapter.

    Synonym Application

    The application directory where the target tables and generated flow will be stored.

    Synonym

    The synonym name for the target table. By default, this is the same name as the source table unless the Application directory is the same, in which case _t is added to the name.

    Table Name

    The name of the target table name in the database. By default, this is the same name as the source table, unless the Adapter and Connection are the same as the source, in which case _t is added to the name.

    Bulk Load

    Specifies the method of loading data. When selected, the database vendors bulk load program is used, instead of inserting records from memory.

  3. In the Target Synonym Application box, select the application directory where to save the flow by either typing in the location of the directory, or clicking the ellipses and manually selecting it from the Select Application dialog box.
  4. Click Save or Run. Two flows will be created, a process flow with the name you specified, and a data flow with the name followed by the table name, for example, flow01_dmhr. The process flow calls the data flow to copy the table.

Procedure: How to Create a Quick Copy for Multiple Tables

  1. Right-click an application directory and click Quick Copy.

    The Quick Copy dialog box opens.

  2. Select the tables you want to copy by selecting the check box in the first column. Doing so allows you to change the Name, which is the synonym, and the Table Name, which is the name of the table in the database.

    Note: If you select the Parallel Execution checkbox, the flows for each table will be run in parallel.

  3. Click Save or Run. Two or more flows will be created, a process flow with the name you specified, and a data flow with the name followed by the table names for each synonym you have selected. For example, flow01_dmreps. The process flow calls all of the data flows.

WebFOCUS

Feedback