Using variables to filter data based on a timestamp

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 (alphanumeric, numeric, text, and 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.

Getting ready

All references to tables in this recipe are taken ...

Get Oracle Data Integrator 11g Cookbook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.