Page History
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.
...
Note title 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 a Transformation or create one.
REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.pngIcons
Description
REPLACE WITH THIS IMAGE: Images/Common_Icons/renamequeryicon.pngClick to Add a transformation.
REPLACE WITH THIS IMAGE: Images/Common_Icons/copyqueryicon.pngClick to Edit the selected transformation.
REPLACE WITH THIS IMAGE: Images/Common_Icons/removequeryicon.pngClick to make a Copy of the selected transformation.
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.
REPLACE WITH THIS IMAGE: Images/Common_Icons/db_column.pngIcons
Description
REPLACE WITH THIS IMAGE: Images/Common_Icons/function.pngClick 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/Entities/Entering a Transformation for an Entity_6.pngClick Insert function to select a database function to be inserted.
REPLACE WITH THIS IMAGE: Images/Common_Icons/file_table.png
REPLACE WITH THIS IMAGE: Images/Common_Icons/refresh.pngClick Clear highlight to clear the highlights (all or by user selection).
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.
fieldNote title Note If multiple columns are selected in the Columns
thefield,
sectionthe 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 Click OK.