MAPPING VARIABLES IN INFORMATICA

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 1/1/1900.

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('1/1/1900','MM/DD/YYYY'),trunc(AgedDate,'DAY'))