What are the output files that are created by the Informatica server at runtime?

At run time, the Informatica server creates the following output files:

Informatica Server Log: This type of file is typically stored in the Informatica home directory and is used to create a log of all status and error messages (default name: pm.server.log). Additionally, you can create an error log for all error messages.

Session Log File: A session log file is created for each session and stores information about the session. B. Summary of initialization process, creation of SQL commands for read and write operations, errors encountered, and usage. Depending on the trace level you set, the amount of detail in the session log file will vary.

Session Details File: Each target in the mapping has its own load statistics file that contains information such as target name, number of rows written, or number of rows rejected. This file can be viewed by double-clicking the session in the monitor window.

Performance Details File: This file is created by selecting the Performance Details option in the session property sheet and contains session performance details that can be used to optimize performance.

Reject File: This file contains data rows that are not written to the target by the writer.

Control File: This file is created by the Informatica server when you run a session that uses an external loader and contains information about the target flat file, such as external loader loading instructions and data format.

Post-session email: Post-session email allows you to automatically notify recipients of session progress. In this case, you can create two different messages. One for successful sessions and one for unsuccessful sessions.

Indicator files: The Informatica server can create indicator files when you use flat files as targets. This file contains a number that indicates whether the target row is marked for insert, update, delete, or reject.

Output File: Based on the file properties entered in the session property sheet, the Informatica server creates the target file when the session writes to it.

Cache files: The Informatica server also creates cache files when it creates memory caches.