A SQL Transformation project generates transformations to be performed on data that exists in a Sybase IQ database.
A SQL Transformation project is specialized to perform SQL transformations where the source and target are both on the same instance of Sybase IQ. As compared to JavaScript transformations, SQL transformations executed in Sybase IQ can enhance performance and scalability.
Setting up the IQ connection – A SQL Transformation project defines the Sybase IQ connection at the project level. The entire transformation project is translated into a single SQL script, and all transformation tasks use the same connection. If you have previously created a SQL Transformation project, the connection details defaults to the most recently used destination connection details. A SQL Transformation project can use database connection profiles that have been defined previously.
A SQL Transformation Project controls the flow of execution, based on the connections between components. You can add the SQL Transformation components from the Component Store to the Design window, connect them, and configure them by setting properties in their respective configuration windows.