You can load a subset of records in a data source during a data load or a dimension build. For example, you can load records 250 to 500 without loading the other records of the data source.
To load a subset of records:
Using a text-editing tool, number the records in the data source.
Set the rules file to ignore the column containing the record number.
See Ignoring Fields.
Define a rejection criterion that rejects all records except those that you want to load.
For example, reject all records for which the ignored column is fewer than 250 or greater than 500. See Rejecting Records.