You can configure the Source Increment Extract Window (in Days) parameter for a PowerCenter resource. To edit the parameter, select the resource in the Resources panel of the Load tab, click Edit Resource, and click the Parameters tab in the Edit Resource window.

To verify a full extract during a resource load, the resource is configured to extract source records that have been inserted or updated within the past 8,000 days of the extract. The default value for the parameter is 8,000.

After the initial extract completes, reset the parameter value based on the frequency at which you load the metadata for the resource. As a guideline, set the parameter value to at least twice the number of days between resource loads. For example, if you load the resource every two days, set the parameter value to four. By doubling the amount of time, Metadata Manager extracts metadata for the current and previous time period. If the previous load fails, Metadata Manager extracts information for the previous period and the current period.

If you do not reset the default parameter value, Metadata Manager extracts metadata for the past 8,000 days when you load the resource.