Validate

Validation is an important step that ensures the consistency and runnability of the captured transformation. When executing the Validate function:

• the query entered by the developer is converted into the effective statement
• the sources and targets entered on the worksheet are verified against the sources actually used in the stored query

The Validate functionality is accessible via the Edit Action dialog with the Validate (lightning) button.

The "Resulting Action to be performed" section displays the SQL query as it is assembled by the module and will later be executed in the database during an actual run. It is important to understand that the resulting SQL query is only generated dynamically at runtime and is not persisted in the generated form. In this case, an Upsert.

If the entered query is faulty, the error message from the target database is displayed. In that case, the query would need to be corrected and validation performed again.

If the query is technically valid, the "Result of Validation" section shows the results of the dependency validation. The objects used in the query are compared against the objects defined in the model. The "Query" column stands for "Used in the query" and the "Model" column for "Defined in the model". All objects used in the query should be defined in the model, as this is a prerequisite for execution control. For example, if you were to delete the connection from STAGE.PART to the transformation in the worksheet model, the validation would look like this and the model should be completed.