Data Filters
You can create simple or advanced data filters. You can also create a set of data filters for each object included in a Data Replication or Data Synchronization task. Each set of data filters act independently of the other sets.
Simple Data Filters
You can create one or more simple data filters. When you create multiple simple data filters, the associated task creates an AND operator between the filters and loads rows that apply to all simple data filters.
If you create a simple data filter on a date field in an Oracle source, the date field must use the default Oracle format DD-MON-YY.
Advanced Data Filters
You can create an advanced data filter to create complex expressions that use AND, OR, or nested conditions. You enter one expression that contains all filters.
The expression that you enter becomes the WHERE clause in the query used to retrieve records from the source. Use an advanced data filter to create a filter on a date field with a non default date format.
For example, an Oracle date field that has the date format 'yyyy/mm/dd:hh:mi:ssam.'
Use the following advanced filter format to create date field:
“DATE_FIELD” > to_date('1998/05/31:12:00:00AM', 'yyyy/mm/dd:hh:mi:ssam')