In this Mapping we will see how to implement the incremental loading..

We will go for incremental loading to speed up the data loading and reduce data actually loaded.

There are different ways we can implement this incremantal loads.

One of the those methods by writing SQL Override in SQL using Mapping variable.

Explanation of the mapping: First we hav to create one mapping variable of type date.

In the source qualifier write the sql override as follows
SELECT SRC_INCRE_LOAD.EMPNO, SRC_INCRE_LOAD.ENAME, SRC_INCRE_LOAD.HIREDATE FROM
SRC_INCRE_LOAD WHERE SRC_INCRE_LOAD.HIREDATE>'$$V_LOAD_DATE'

In the expression assign sysdate to mapping variable to update the mapping variable because from next load it will pick the records greater than today's date.It will accept only recent records
Output Port :: INCRE_LOAD
SETVARIABLE($$v_incre_load,sysdate)