Reset Target Source Schema Field Lengths

If a Source was added in Target Design during a System Type import, and the System Type tables for a Source contained an invalid length for a column, use the Reset functionality to update a Source table with the column’s correct length.

NOTE: Updates to field lengths in System Types are not reflected in Target or Source tables until a user clicks Create on the Targets or the Target Sources page. System Types are defined and the field lengths are modified in Common. Refer to System Types for more information.

NOTE: To reset the length, the user must know the table and field name with the invalid length for the Target or Source.

To use the reset feature in Common:

  1. Select System Types in the Navigation pane.
  2. Click the Tables icon for the Target or Source System Type.
  3. Click the Fields icon for a table.
  4. Click Edit.

    View the field descriptions for the System Types - Table Fields page.

  5. Enter a value in the LENGTH field.
  6. Click Save.
  7. Navigate to Map.
  8. Click the Targets icon on the Process Area Launch page.
  9. Click the Sources icon for a Target.
  10. Click Vertical View for a table for a Target or a Target Source.

    NOTE: Do not click the Vertical View icon for a [Target Rules] Target Source.

  11. Click the Schema Columns icon.
  12. Click Reset; a confirmation message displays.
  13. Click OK.