Overview of SQL Transformation

SQL Transformation transforms your SQLs into target equivalent SQLs or performs inline edits. It transforms the legacy code, logic, and ETL workflows to the preferred target engine. It takes advantage of the data store-specific, ready-made library of user-defined functions (UDFs) and keywords to fill the target-system gaps. Moreover, you can save a huge amount of development, testing, and validation effort.

While transforming the queries into the target, it is advisable to provide metadata information to increase the possibility of correct transformation and validation. You can associate either live or offline metadata with the SQL transformation stage.

This feature allows you to:

Transforms your SQLs into target equivalent SQLs.
End-to-end unit level and script level validation to validate the queries.
Highlights the transformation difference between the source and the transformed query.