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:
REPLACE WITH THIS IMAGE: Images/Entities/Entering a Transformation for an Entity.png
or by right-clicking on the entity in the repository tree and choosing Properties:
REPLACE WITH THIS IMAGE: Images/Entities/Entering a Transformation for an Entity_1.png
- Select the Data Transformation tab.
REPLACE WITH THIS IMAGE: Images/Entities/Entering a Transformation for an Entity_2.png
Note |
---|
The Data Transformation tab is only visible if data transformations are enabled in the category settings, refer to Entity/ General Settings for details. |
- Select a Transformation or create one.
Icons
Description
REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png
Click to Add a transformation.
REPLACE WITH THIS IMAGE: Images/Common_Icons/renamequeryicon.png
Click to Edit the selected transformation.
REPLACE WITH THIS IMAGE: Images/Common_Icons/copyqueryicon.png
Click to make a Copy of the selected transformation.
REPLACE WITH THIS IMAGE: Images/Common_Icons/removequeryicon.png
Click to Delete the selected transformation.
- In the right pane, enter the following details for the transformation.
- Select the buttons to the right of the Change and Condition fields to define change and conditional functions for the selected columns.
Icons
Description
REPLACE WITH THIS IMAGE: Images/Common_Icons/db_column.png
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.
REPLACE WITH THIS IMAGE: Images/Common_Icons/function.png
Click Insert function to select a database function to be inserted.
REPLACE WITH THIS IMAGE: Images/Entities/Entering a Transformation for an Entity_6.pngREPLACE WITH THIS IMAGE: Images/Common_Icons/file_table.png
Click Clear highlight to clear the highlights (all or by user selection).
REPLACE WITH THIS IMAGE: Images/Common_Icons/refresh.png
Click Refresh highlights to refresh the text field to check the highlighting.
- Enter Encapsulate characters to be used in the Preview section.
- 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.
- Click the Test button to test your transformation and to view the results.
REPLACE WITH THIS IMAGE: Images/Entities/Entering a Transformation for an Entity_7.png
- Click OK.