The exception data store can store up to 20,000 issues for a given exception task job.

An exception data file that you download for a job from the exception data store can contain up to 20,000 issues.

By default, the exception data store retains exception job data for 45 days.

Informatica Intelligent Cloud Services

deletes data for jobs outside the 45-day time frame. To request a shorter default time frame for your organization, contact Informatica Global Customer Support.

When you opt to store job data on your local system, the exception task writes the results as a comma-separated file to the flat file connection that the Secure Agent can access. Informatica does not impose a limit on the quantity of data that the exception task writes to the file.

You can set up permissions to protect your data from other users. For information about privileges and permissions on the exception tasks, see Exception management prerequisites.

The application in which you open the exception data file may apply a limit to the quantity of data that it displays. For example, Microsoft Excel places a limit on the number of rows and columns that it displays in a single worksheet. Consider creating a backup copy of the file that you download before you open and save in another application.