Creating Missing Destination Tables

Create all missing destination tables using the Table Creation window.

1. Click the Create Missing Destination Tables icon to create all destination tables that do not yet exist on the destination database. When the Table creation window displays, source metadata gets loaded for each missing destination table. After the metadata is loaded for a table, you can select the table and edit its attributes.
   If source metadata cannot be loaded for a destination table, the table is marked with an error icon and it does not have any attributes.
   If source metadata is not loaded for one or more tables in the destination table list, you can attempt to load metadata from tables in a database. Click Get Metadata For All Tables to load the metadata for all tables, or click Get Metadata For Selected Tables to load the metadata for selected tables in the list.
   From the Get Attributes From Database window, select a Connection Profile or enter database connection information. Click Test Logon to the the connection. Click Get Attributes to load the metadata for each destination table. Metadata is loaded by matching the destination table name to the name of a table on the connected database. If a match is found, the matching table metadata is loaded for the destination table.
   Note: If you have enabled Replication Server materialization in the Source tab, the UPDATE, DELETE work tables to be created also appear along with the list of destination tables.
2. Select one or more destination tables from the navigator.
3. In the Attributes pane, verify the attribute mapping of the selected table. Default mappings are marked with a question mark (?).
4. Specify a filter condition to filter the listed attributes.
   To filter the attributes, select the Hide Mapped Attributes option to hide all attributes that have been mapped to a destination datatype.
   You can filter on the source attribute name, description, and datatype. To apply one of these filters:

   • Select a filter from the Add Filter drop-down list.

   • Select '=' or '!=' from the Operator drop-down list.

   • Enter a GLOB expression in the Filter text field.

   • Click the Add A Filter Condition To The Attributes List icon to add the filter.

   You can also group unique datatypes by applying the Unique Data Type filter. All attributes that share the same datatype, length and scale are grouped together into a single entry in the Attributes table. While this filter is applied, any changes to the mapping of an attribute is also applied to attributes with the same datatype, length and scale.

   • Select Unique Data Types from the Add Filter drop-down list.

   • Click the Add A Filter Condition To The Attributes List icon to add the filter.

   Note: After applying the Unique Data Types filter, you cannot apply any more filters.
   The list of applied filters is displayed at the bottom of the Attributes table. Filtered columns display a small filter icon next to the column name. To remove all filters applied to the Attributes table, click Clear All Filter Condition From The Attributes List icon in the Attributes toolbar.
5. Map the attributes to a destination datatype by selecting one of these options:

   • Manual mapping – click and edit the target datatype, length and scale values in the Attributes table.

   • Map selected – select the attributes you want to map to the same data type, length, and scale in the Attributes table and click the Map Selected Attributes To A Target Data Type icon in the Attributes toolbar. Then, enter the target datatype, length and scale values and click Map to apply the mapping.

   • Map Visible – maps all attributes shown in the Attributes table to the same datatype, length, and scale. Click the Map All Visible Attributes To A Target Data Type icon from the toolbar and enter the target datatype, length, and scale values. Then, click Map to apply the mapping.

   • Map All – maps all attributes in all tables to the same data type, length, and scale. Click the Map All Visible Attributes To A Target Data Type icon in the Attributes toolbar and enter the target datatype, length, and scale values. Then, click Map to apply the mapping.

6. Click Create.
   A progress bar displays the table creation progress as well as any errors that occur during the process. At any time, you can cancel the table creation process by clicking Cancel, which opens a dialog that gives you an option to drop the tables you have created. Click Yes to drop the new destination tables, or No to keep them.
   Click Close to return to the Table Creation window. Any tables that could not be created are marked with an error icon. Any tables that were created are marked with a created icon and cannot be edited.
   Click the Reset To Default Target Data Types icon to reset all table attribute mappings to their default mappings. This resets the mappings of tables that have not been created in the destination database.
   Note: The Table Creation window does not attempt to create destination tables that do not have source metadata or do not have a complete attribute mapping.
7. Click Close to return to the Tables tab.
   Note: If you attempt to execute an EL Project that is configured to load a non-existent destination table, the Table Creation dialog appears, prompting you to create the missing destination tables. After these tables are created, click Close to continue with the project execution, if the project is valid.