Table

Overview

The table section displays individual table mappings used in the data migration. Users can define table mappings, set SQL overrides, and configure schema details.

View

Add a table

To create a table, follow these steps:

1. Click Create New.

2. Enter a valid name in the Table Name field.

   

3. Enter a valid name in the Physical Table Name field.

   

4. Enter a valid number in the Table Sequence field.

   

5. Optional. Add table mappings to the table. For more information, see Mappings.

6. Optional. Add group to the table. For more information, see Groups.

7. Click Save.

Mappings

The Mappings tab defines how data is mapped between the Source and the Target.

Field	Description
Sequence	Displays the sequence number.
Mapping Details - Action	Specifies the operation to perform. The following are the possible values: MIGRATE DELETE
Mapping Details - Map Sequence	Specifies the order which the mappings will be executed.
Mapping Details - Bucket Count	Defines the number of data buckets used for parallel processing.
Mapping Details - Parallel Count	Sets the number of parallel processes running simultaneously.
Target - Target Context ID	Specifies the target database context for the selected action.
Target - Target Schema	Specifies the schema where the selected action is applied.
Source - Source Context ID	Identifies the source database context for reference.
Source - Source Schema	Specifies the schema which contains the source data.
Source - Source Table Name	Specifies the source table name for reference.
Source - Alias	Specifies the alternative name for the source table.
SQL Overrides - SQL Condition	Applies SQL filter applied during the execution.
SQL Overrides - Source Query	Retrieves data using complete SQL source query.
SQL Overrides - PK Override	Defines the primary key query for migrating data.
SQL Overrides - SQL Override	Modifies SQL query to override the SQL execution.
SQL Hints - Insert Hint	Specifies optimization hints for insert operations.
SQL Hints - Select Hint	Specifies optimization hints for select operations.
SQL Hints - Delete Hint	Specifies optimization hints for delete operations.
SQL Controls - Standalone SQL	When ticked, enables SQL executions that can be processed independently.
SQL Controls - Ignore SQL Errors	When ticked, allows the process to continue even if SQL errors occur.
SQL Controls - Not Threadable	When ticked, restricts SQL executions in parallel with other data migration processes.
SQL Controls - Disabled	When ticked, prevents SQL executions operations.
Action	Displays that allows you to remove the mapping.

Add a table mapping

Click the Add button to add a new table mapping.

Groups

The Groups tab displays the group that the table is linked to.

Field	Description
Sequence	Displays the sequence number of the group.
Group Name	Name of the group.
Description	Description of the group.
Action	Displays that allows you to remove the group.

Add a table

To add a table, select them from the Add tables to this Group dropdown.

Modify a table

The Table module allows you to update the details of an existing table. To make modifications, select the table from the list and change the values in the fields as needed.

Delete a table

To delete a table mapping, click the and select Delete.

When deleting a table mapping, ensure that you are deleting the correct table mapping because it will be permanently removed from the system.