O'Reilly logo

Oracle Data Integrator 11g Cookbook by Peter C. Boyd-Bowman, Denis Gray, Christophe Dupupet, Julien Testut

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required