For each data model you can define transformations to be executed automatically after the data model is deployed.

You can define transformations of these categories:

• Modeling: You can use modeling transformations to create views in the target database. These views are created based on the business entities that are created in the target database on deploy.
• Instrumentation: You can use instrumentation transformations to create objects, stored procedures, and schemas in the target database. You can also use these transformations to do calculations on the metadata that is exported on deploy.

A transformation contains one or several SQL statements which define the transformation actions to be done.

Standard procedure

1.	Go to Data modeling studio > Data modeling studio > Data models.
2.	In the list, find and select the desired data model.
3.	Click Transform.
4.	Sub-task: Add several transformations at once.
4.1	You can add several transformations at once.
	Click Add multiple....
4.2	In the list, find and select the desired transformations.
	Note: Only the transformations of category 'Modeling' and 'Instrumentation' are shown in the list.
4.3	Click Ok.
5.	Sub-task: Add one transformation.
5.1	You can add one transformation.
	Click Add.
5.2	In the Template field, enter or select a value.
	Note: Only the transformations of category 'Modeling' and 'Instrumentation' are shown in the lookup.
6.	Sub-task: Define transformation sequence.
6.1	Define the sequence in which the transformations are applied.
	To move a transformation one position up, click Up.
	Note: You can also manually set the sequence in the Order field.
6.2	To move a transformation one position down, click Down.
	Note: You can also manually set the sequence in the Order field.
7.	Click OK.
8.	Close the page.

Notes

If the data model is already deployed, you can apply some transformations without re-deploying the data model. To do so, on the Select transformations dialog, to apply:

• A selection of transformations, select the transformations, and click Apply selected.
• All defined transformations, click Apply all.