You use the Select Record dialog box to determine which data-source records are loaded during a data load or a dimension build.
In the Boolean group, you select Or (to load records that contain a field that meets any selection criterion) or And (to load records that contain a field that meets all selection criteria). The default selection is And.
In the following columns, you define the criteria by which data records are selected for loading:
Type—Select String or Number, to base a selection criterion on, respectively, a string or numeric value. The default selection is String.
String/Number—Enter the string or number on which to base the selection 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 loaded. 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 loaded.
Note: | The Contains and “Does not contain” conditions can be used only with strings. |
Case-sensitive—If you selected String and you want the selection 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.