IQE_INCREMENTAL function in ION Query Editor

In the ION Query Editor mode the incremental load can be defined using the “IQE_INCREMENTAL” function.

The function generates the condition for the incremental load for single incremental column, or for two columns in parent/child group. In case there is no new record, the condition is replaced by FALSE value. The real database table and column names must be used, not alias.

Function parameters: (TableName, ColumnName (Optional)ChildColumnName).

For example:

SELECT
    [CUST].[CUSTOMERID] AS [CUSTOMERID],
    [CUST].[COMPANYNAME] AS [COMPANYNAME],
    [CUST].[CONTACTNAME] AS [CONTACTNAME],
    [CUST].[CONTACTTITLE] AS [CONTACTTITLE],
    [CUST].[ADDRESS] AS [ADDRESS],
    [CUST].[CITY] AS [CITY],
    [CUST].[REGION] AS [REGION],
    [CUST].[POSTALCODE] AS [POSTALCODE],
    [CUST].[COUNTRY] AS [COUNTRY],
    [CUST].[PHONE] AS [PHONE],
    [CUST].[FAX] AS [FAX],
    [CUST].[TEST] AS [TEST]
FROM
    [CUSTOMERS] AS [CUST]
WHERE
    (([CUST].[COMPANYNAME] LIKE '%AN%'))
    AND (
        IQE_INCREMENTAL(
            [CUSTOMERS] AS [CUST],
            [CUSTOMERID],
            [CONTACTTITLE]
        )
    )