Customizing a template

After a data migration, you may add custom fields to the FINAL, HIST and STG tables.

To add fields:

1. In the web interface, run the Info Page:

   1. Right-click the Load Data to FINAL and HIST Tables data model and select View Info Pages.

   2. In the Add Field to the related table section, click the prompt icon and select the Table Name from the list.

      

   3. Enter the field in the Column Name.

      To add multiple fields, insert a semi-colon (;) between each field, without spaces.

   4. Select the SQL Data Type from the drop-down list; for example, varchar(max).

   5. Click Add.

   

2. Add the field as described in the Data Model Designer:

   1. Right-click the Data Model to change and select Design Data Model.

   2. Select the field created in the previous step.

   3. Set the properties as required.

   4. Click Edit on the left and set the Edit Level parameter to 10.

   

3. Add the field to the view:

   1. Open the worksheet.

   2. Click the Dimensions and Measures icon on the right.

   3. Drag and drop the dimension where appropriate.

   4. Save the worksheet.

4. In DataSync, open Extraction 1 and map the new field(s).

   1. Open the appropriate table.

   2. Click the Fields link.

   3. Click Add and follow the steps as described in Configuring Table Fields.

   4. Click Save.

   

5. Open Extraction 3 and map the new field(s) as described in Step 4.

   

   You can reorder the fields using the Organize Fields icon on the upper right-hand corner.