Benefits and capabilities

When you create a data subset, you can define subset criteria (such as a where condition), which will limit the amount of data that will be extracted for the subset. As a result, the storage requirements in the target database are reduced. This is one of the most important benefits of data subsetting, since it helps to reduce expensive storage costs.

You can select multiple applications, that is, schemas (in the case of multi-tenanted databases) for the subset. The definition of tables associated with these applications and the relationships between them will be extracted from the Application Data Model into the subset definition, along with additional metadata of the constraints and indexes. You can totally avoid the manual labor normally associated with collecting this information and writing appropriate scripts.

Table rules can be defined with where clauses and bind variables that limit the data that is extracted. Table statistics are then analyzed to get an estimate...