Extract criteria
File-AID/RDX enables you to control the scope and depth of the extract process by allowing you to define extract criteria. Extract criteria includes information about following criteria:
- Navigation controls
- Sampling controls
- Selection criteria
Navigation controls apply to the list of relationships defined for the driving object. They determine how File-AID/RDX chases the relationships and whether or not to extract direct dependents, parent records, sibling or indirect dependents. The navigation controls can be set globally or individually. You also can exclude objects or relationships manually from the extract to further define the scope of the extract.
Sampling controls can limit the number of records to be extracted from each relationship or object, specify the number of records to skip, or specify the maximum number of records to extract from all objects. The controls also include cycle count and what action to take when the maximum counts have been reached.
Selection criteria can be specified for any object in the extract. It consists of conditions that individual columns or fields must meet. File-AID/RDX extracts only records that contain values that meet these conditions. For complex extracts, you can define multiple selection criteria sets.
You can save extract criteria in an extract request file so you can use it at a later time. For more information about the Extract Request File, see Extract/Load/Delete Request File and File-AID/RDX Extract/Load/Delete Request File.