One of the most frequent uses of variables
is to apply a data filter to an ODI procedure or interface. Once a variable has been defined either globally or within a project, it can be populated using one of several different methods (that is, refreshed, assigned, passed as a parameter, and so on). Once the variable has acquired a value, it can be used as a filter condition within another project component. ODI currently supports four variable data types (
date), any of which can be used as a data filter. In this recipe, we will discover how to use variables in order to filter data based on a timestamp.
All references to tables in this recipe are taken ...