This article explains what data selection rules are and how to create them. It explains their various operators and how to apply data selection rules with Mappings.
They are a set of rules that must be satisfied during the selection of data. After satisfying selection rules, data is loaded into the staging database. Data selection rule is a filter applied for the staging database at the field level in the data source tree. Similarly, data selection rules are applied for the data warehouse database at the field level of the data warehouse tree.
Values must be either integers or letters. You can also specify a list of values by entering comma-separated values. The following operators are available when you create selection rules.
In order to select all tables from a data source and bring into your staging database, click Select All in the Data Selection Pane.
Another way to select tables and bring into staging database is to right-click the data source, click Automate, and then click Select Tables and Fields
The wizard will appear and allow you to proceed:
You have the option to specify an AND operator, as well as an OR operator while creating a data selection rule.
Using an OR Operator
By adding additional filter on a table, we can create an OR operator. Our first example will use the Item table.
A filter icon is created under the Item table that indicates to only allow values where Item Category Code equals BAGS and Product Group Code equals SPORTS BAG.