Certain Transformation are easier to be created when a graphical tool can enable the necessary tables/views/columns to be seen. InfoNaut is query tool that ships with CONNX and has a graphical query tool that enables transformations to be easily created.

 

To use the Query Builder, Go to the CONNX Driver section of the Windows Start menu and select InfoNaut.  Establish a DSN-less connection to the CDD that was uploaded to DataSync and select Build Query from the tool bar.

 

The QueryBuilder screen appears as follows:

 

 

 

In this example, the two tables (CUSTOMERS_RMS and ORDERS_RMS) will be used to generate a transform that produces a combined table that produces output only if the order occurred in 1997.

 

 

The SQL Generated does not include the condition where the year must be 1997. The SQL to generate this is YEAR(CISAM.mike.Orders_cisam.ORDERDATE) = '1997' . This can be added in the grid below.

 

 

More complex expressions can be created using the Expression Builder as described in the next section.

 

Click Done and the SQL Query will be copied to the Free-Form area of the Transformation.

 

After the text has been copied, click the next button to continue to Step 2 Target