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.
All references to tables in this recipe are taken from the data samples described in the Preface of this book. Be sure to reverse engineer the DEMO_SRC
and DEMO_TRG
data models before beginning this recipe. Also, be sure to import the IKM – SQL Control Append
KM.