Designing Data Integrator Projects

Viewing the SQL Code

You can view SQL code generated for each table and operator in the ETL collaboration canvas.

ProcedureTo View SQL Code

  1. Open the ETL collaboration you want to view.

  2. Right-click the table or operator on the canvas and click Show SQL.

    The Output section in the lower panel of the NetBeans window displays the generated SQL code, as shown in the following figure.

    Figure shows the SQL code generated for the select
ETL component.