Tasks

Back Next

Data filter variables

Data filter variables represent the date or time that a task previously ran. Use data filter variables to help capture the source data that changed since the last task run. You can use data filter variables in simple and advanced data filter conditions.

You can use the following data filter variables:

Variable	Description
$LastRunDate	The start date in GMT time zone of the last task run that was successful or ended with a warning. Does not include time. For example, 2018-09-24. Can be used as a value for filter where the field type is DATE.
$LastRunTime	The start date and time in GMT time zone of the last task run that was successful or ended with a warning. For example, 2018-09-24 15:23:23. Can be used as a value for filter where the field type is DATETIME. You can't use the $LastRunTime variable with DATE fields .

You can't use data filter variables in expressions in mappings SQL ELT mode.

For example, you can include the following simple filter condition:

LastModifiedDate > $LastRunTime

Consider time zone differences when comparing dates across time zones. The date and time of the $LastRunDate and $LastRunTime variables are based on the time zone set in

Informatica Intelligent Cloud Services

. The date and time of the actual job is based on the GMT time zone for Salesforce sources and the database server for database sources. The difference in the time zones may yield unexpected results.

Data filters

Download Guide

Watch

Comments

Cloud Data Integration Homepage