Advanced SQL Preview

This window displays the actual SQL that will be executed when you click Finish to complete the wizard. The code usually consists of a CREATE VIEW or CREATE TABLE statement followed by a COMMENT statement. This code may be useful for debugging situations when the wizard does not complete successfully or does not generate the desired results.

You can save the code in two ways:

Click OK to return to the Preview Transformation window.

To generate the SQL that performs a sequence of one or more transformation, use the the Lineage Viewer