Skip to main content

Defining tables and full load data

In the Tables tab, you specify the location of your Full Load data files and define how the source tables will be created. During Full Load, Replicate will copy the source tables to the target endpoint.

To define a table:

  1. In the Tables tab, click New Table.

    The New Source Table window opens.

  2. In the Table name field, specify the name of the table.
  3. In the Location of full load data file(s) field, specify location of the delimited text files that contain your full load data. Wildcard characters are supported.
  4. To add a field, click Add Field. Then, click the default column name to edit it.
  5. To specify a data type, select the row and then select a type from the drop-down list in the Type column.
  6. When the CLOB, NCLOB, STRING, or WSTRING data types are selected, you can also set a data subtype. Select either JSON or XML from the drop-down list n the Subtype column. Make sure that the new data in the column will be compatible with the selected subtype. The default is Regular, which means that the selected data type will be used without a subtype.

  7. (Optional) Click in the Key column to add or remove a Unique Index to/from a column.
  8. To create the table, click OK.

    The table will be added to the list of tables in the Tables tab.

    See also the example for Creating a Table.

To edit a field:

  • Double-click the column in the New/Edit Source Table dialog box and then edit the values as described above.

To delete a field:

  • Select the column in the New/Edit Source Table dialog box and then click the Delete Field button.

To change the position of a field:

  • Select the field and then click the Up/Down and Move to Top/Move to Bottom buttons as required.

To edit a table:

  • In the Tables tab, either double-click the table or select the table and then click the Edit button. Edit the table as described above.

To delete a table:

  • In the Tables tab, select the table and then click the Delete button.
Creating a Table

The source table definition must match the column data values in the Full Load file(s). So, for example, if the Full Load data file contains the following delimited columns:

22,January,2014,male,5463565

12,May,2011,female,3236776

9,March,2009,male,9648675

30,June,2002,female,3458795

Information note

Boolean values must be expressed as the digits 1 (TRUE) or 0 (FALSE) and not TRUE or FALSE.

Then the table definitions would look something like this:

The Edit Source Table interface. It contains fields for "Table name" and "Location of full load data file(s)". Fields can be added, removed, and reordered using interface buttons. The fields can be modified by assigning a Key, Name, and Type.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!