Creating mapping Variable

1. Go to Mappings Tab, Click Parameters and Variables Tab, Create a NEW port as below.

$$LastRunTime        Variable         date/time         19        0          Max

Give an Initial Value. For example 10/29/2011.

2. IN EXP Transformation, Create Variable as below:

SetLastRunTime (date/time) = SETVARIABLE ($$LastRunTime, SESSSTARTTIME)

3. Go to SOURCE QUALIFIER Transformation,

Click Properties Tab, In Source Filter area, ENTER the following Expression.

UpdateDateTime (Any Date Column from source) >= '$$LastRunTime'

AND

UpdateDateTime < '$$$SessStartTime'

Handle Nulls in DATE

iif(isnull(AgedDate),to_date('10/29/2011','MM/DD/YYYY'),trunc(AgedDate,'DAY'))