Entering a Transformation for an Entity

To enter a transformation on an entity, select the Properties screen for that entity, either by right-clicking on the entity in the diagram and choosing Properties:
 
or by right-clicking on the entity in the repository tree and choosing Properties:

1. Select the Data Transformation tab.
   
   

   Note

   The Data Transformation tab is only visible if data transformations are enabled in the category settings, refer to Entity/ General Settings for details.
2. Select a Transformation or create one.

   Icons	Description
   	Click to Add a transformation.
   	Click to Edit the selected transformation.
   	Click to make a Copy of the selected transformation.
   	Click to Delete the selected transformation.

3. In the right pane, enter the following details for the transformation.
4. Select the buttons to the right of the Change and Condition fields to define change and conditional functions for the selected columns.

   Icons	Description
   	Click Highlight attribute to highlight some text in the change/condition field, which will then be replaced by the columns selected in the Columns field.
   	Click Insert function to select a database function to be inserted.
   	Click Clear highlight to clear the highlights (all or by user selection).
   	Click Refresh highlights to refresh the text field to check the highlighting.

5. Enter Encapsulate characters to be used in the Preview section.
6. Select the Define as SELECT query checkbox to create a SELECT query in the Preview section. If the checkbox is not selected, an UPDATE query is created in the Preview section.
   

   Note

   If multiple columns are selected in the Columns field, the Preview section will contain multiple queries, separated by semicolons.

7. Click the Test button to test your transformation and to view the results.
   
8. Click OK.