Table of Contents

Search

  1. Preface
  2. Data integration tasks
  3. Mapping tasks
  4. Dynamic mapping tasks
  5. Synchronization tasks
  6. Data transfer tasks
  7. Replication tasks
  8. Masking tasks
  9. Masking rules
  10. PowerCenter tasks

Tasks

Tasks

Data subset

Data subset

You can extract a subset of data from the source and move to the target in a
masking
task.
The
masking
task maintains primary and foreign key relationships in the subset data and reconciles the object relationships in the subset data.
Configure the following data subset options from the
Data Filters
page:
Data Filters
The data filter that you want to apply on the source. You can create a simple or an advanced data filter for an object. You can apply a filter to a single object in a task. You can apply multiple filters on the same object. You can add one advanced filter in a task. You can also use the filter values from a parameter file and mention the file name in the task.
Relationship Behavior
You can configure relationships when you select multiple source objects. When you perform a data subset operation, the
masking
task selects all the parent records of an object to maintain referential integrity. The task selects the child record if you configure to include the child objects. You can configure relationships of the child objects after you apply a data filter. You can select the child objects that you want to include in the data subset. You can view and download the schema graph that shows the graphical representation of the relationships between the source objects.
You can view the number of join operations that are required to compute a subset operation. View the sequence in which the task selects the records to create a data subset.
Subset Statistics
You can view the subset statistics such as total number of rows, the number of subset rows, and the subset size for each source object. The source contains large amount of data, but the target in which you want to create a subset might not contain enough space. To evaluate the target size, you can estimate the data subset. After you estimate the subset, you can view the estimated target size on all the
masking
task pages. If the estimated target size is large, you can update the task and estimate the subset again.
You can estimate the data subset size for multiple source objects.

0 COMMENTS

We’d like to hear from you!