You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Users are able to configure data type mappings to operate any way they wish. This is achieved using the Data type mappings manager activated from the Tools menu.
Choose Manage data type mappings from the Tools menu:
REPLACE WITH THIS IMAGE: Images/Wizards/Managing Data Type Mappings.png
The Data type mappings manager displays the data type mapping sets in the left pane. Each mapping set contains a list of mappings, which are displayed in the right pane.
REPLACE WITH THIS IMAGE: Images/Wizards/Managing Data Type Mappings_1.png
The top right pane displays the From side of the mapping:
REPLACE WITH THIS IMAGE: Images/Wizards/Managing Data Type Mappings_2.png
while the bottom right pane displays the To side of the mapping:

Note

The various To mapping fields are only active if the respective From mapping fields are not empty, i.e. a value has been entered.

REPLACE WITH THIS IMAGE: Images/Wizards/Managing Data Type Mappings_3.png
The matching mechanism of the data type mappings operates as follows:

  • * matches NULL, Numeric value or text string
  • 5-* matches N > 4
  • *-5 matches N <= 5
  • null matches NULL
  • Text string 1 identical to text string 2

    Icons

    Description

    REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png

    Click to Add a data type mapping within a data type mapping set.

    REPLACE WITH THIS IMAGE: Images/Common_Icons/renamequeryicon.png

    Click to Edit the selected a data type mapping within a data type mapping set.

    REPLACE WITH THIS IMAGE: Images/Common_Icons/copyqueryicon.png

    Click to Copy the selected a data type mapping within a data type mapping set.

    REPLACE WITH THIS IMAGE: Images/Common_Icons/removequeryicon.png

    Click to Delete the selected a data type mapping within a data type mapping set.

    REPLACE WITH THIS IMAGE: Images/Common_Icons/undo.png

    Click to Restore datatype mapping files.

    Note
    • The Scale is the number of digits to the right of the decimal point in a number.
  • The Precision is the total number of digits in an number.|

    Note

    The following generic data types in 3D are used for generated attributes so they can be mapped to the correct RDBMS target.

  • tgt_integer
  • tgt_char
  • tgt_varchar
  • tgt_date
  • tgt_datetime|
  • No labels