Certain Transformation are easier to be created when a graphical tool can enable the necessary tables/views/columns to be seen. Datasync has a graphical query tool that enables transformations to be easily created.
To navigate to the Query Builder, the user must select the Query Builder Button.
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.
By clicking the next button, the user will be directed to Target Sub-Tab.