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

Automatic task recovery

Automatic task recovery

In a
masking
task, you can estimate a subset. If you estimate the subset and then run the task, the task recovers from the previous stage and continues to the next stage.
When you configure data subset filters and run a
masking
task, the task runs through the staging, subset estimation, target load, and staging drop stages.
You can estimate the subset to evaluate the target subset size before you run the task. When you click
Estimate
, the task stages the records and estimates the subset. After you estimate the subset, if you click
Run
, the task resumes to load the target and then drops the staging tables.
If you save and run a task without estimating the subset, the task runs through all the stages and drops the staging tables at the end.
Every task has an associated staging schema. After the task runs through all the stages, the task drops staging tables if there are no errors. If you did not choose to drop the staging tables and if there are error rows present, the task does not drop the staging tables. If you run the same task after a few days, the task performs the data subset operation on the old data. To run the task with updated data, you must first reset the task. When you reset the task, the task status returns to the start stage. You can then estimate the subset and then run the task or directly run the task. In both cases, the task runs through staging and estimation stages and then loads the tables into the target.

0 COMMENTS

We’d like to hear from you!