Create Target Tables

This topic is related to the following sections:

• Importing Datasets into Mapping

• Build XML Scripting for Dataset

• Create & Maintain Target Sources

• Mapping the Fields of a Datasource

• Create Working Tables

• Create Reports

• Value Mappings by Object

• Execution of the ETL Jobs

• Mapping History

• Maintain Mapping Status

• Maintain Target Reports

• Execute Metric Calculations

• Data Type Conversion in the SKP

About Creating Target Tables for Mapping

The page below is accessed by pathway Migrate > Mappings from the Syniti Migrate Homepage.

As part of the process for importing the dataset into the Release for mappings, the target tables are automatically built within the database, and the names display within the column Target Table. This section is useful should the auto build process fail.

The CREATE TARGET TABLES button builds the table within the working db separate from XML Build - The process of creating the Target Table is set as a separate task from Building XML. Regardless of the ETL Tool associated with the Release, the action of creating target tables is a separate function. Within the Mappings page, the Release Dataset Details window stores this button. When the Dataset is Imported into the Project Release, the system auto generates the Target Tables associated with the Dataset. This section is used for manual updates to create target tables.

Note

For External ETL Tools such as SAP Data Services - The XML Build button still creates a target table first and then build out the XML Scripting for the ETL Tool (Non Migration ETL Tool), and any subsequent changes to mapping that alters the Target table is updated within the Database using the CREATE TARGET TABLES button.

This step is relevant once the Dataset has been imported to the Release within Mappings. Also, if using an ETL Tool other than Migration, the step for Building XML for the Dataset would run in conjunction with this step.

Create a Target Table

From within Mappings page, click on the Edit  icon for the Dataset to view the Release Dataset Details. Click on CREATE TARGET TABLES  button initiate a Job Queue to build all target tables for this Dataset. This Job also imports all Metadata (columns) for the tables automatically.

Note

Should the Release have an ETL Tool setting as SAP Data Services, then the section for SAP Data Services is visible. Otherwise, it is hidden.

A warning displays "Create Target Tables?" - click OK to proceed.

If successful, a message displays at page bottom - "Create Target Tables is added to Job Queue Successfully."

View the Job Queue

To determine that the job ran successfully, use pathway - Administer > Job Queues to view the job for this process. This job is named 'Create target tables for dataset' and each target table is listed as a Step in the right side panel. To view the details of the step, click on the Debug Log icon.

Note

This Job also imports all Metadata (columns) for the tables automatically.

If the current Job created an actual table within the database, there is a Log Entry with Message as shown in the image below. Notice that the Message indicates that CREATE TABLE was performed successfully

If the current Job did NOT create an actual table within the database, there is a Log Entry with Message as well. In this case, the table may already exist within the working database, and so this build is not necessary.

Once the new Target table is created, the name is listed in the grid for Targets in Mappings page and as a field in the Target Details.

Create a Target Table from within Target details

The same process may be run from within a specific Target by a click on the BUILD TABLE  button. Follow the same steps for validation that this table is created in the database.