Question

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

Answer 1

The output files created by the Informatica server at runtime are listed below:

1. Informatica Server log: Informatica home directory creates a log for all the error messages and status.
2. Session log file: For each session, a session log file stores the data into the log file about the ongoing initialization process, SQL commands, errors, and more.
3. Session detail file: It contains load statistics for each target in mapping, including data about the name of the table, no of rows written or rejected.
4. Performance detail file: It includes data about session performance.
5. Reject file: Rows of data not written to targets.
6. Control file: Information about target flat-file and loading instructions to the external loader.
7. Post-session email: Automatically delivers session run data to designated recipients. 
8. Indicator file: It contains a number to indicate whether the row was marked for insert, delete or reject, and update.
9. Output file: Informatica server creates a target file based on the details entered in the session property sheet.
10. Cache file: It automatically builds, when the Informatica server creates a memory cache.