You use the Reject Record dialog box to determine which data-source records are not loaded during a data load or dimension build.
In the Boolean group, you select Or (to reject records that contain a field that meets any rejection criterion) or And (to reject records that contain a field that meets all rejection criteria). The default selection is And.
In the following columns, you define the criteria by which data records are rejected:
Type—Select String or Number, to base a rejection criterion on, respectively, a string or numeric value.
String/Number—Enter the string or number on which to base the rejection criterion.
Condition—Select Equal, Not equal, Greater than, Greater than or equal to, Less than, Less than or equal to, Contains, or Does not contain. The condition that you select is combined with your Type and String/Number selections to create a criterion. For example, if you select Or and String, enter XYZ, and select Equal, all records that contain a field with a value of XYZ are rejected. For example, if you select Or and Number, enter 5, and select Less than or equal to, all records that contain a field value that is less than or equal to 5 are rejected.
Note: | The Contains and Does not contain conditions can be used only with strings. |
Case-sensitive—If you selected String and you want the rejection criterion to be case-sensitive, select the option.
To create a criterion, you click the New button. To delete a criterion, you select it, and click the Delete button.