Tanubhrt.This.Side

Output Files in Informatica

Informatica is a very powerful ETL tool created by Informatica Corp. This tool allows the miners to actually do transformations on the data and load it into the data warehouse for further analysis.

Informatica creates the following output files –

    1. Informatica Server Log – This file creates the log for all the status and error messages. The files are created in Informatica server log. The default name is pm.server.log
    2. Session Log File – This file writes details such as initialization process, creation of SQL commands for reader and writer threads, errors encountered and load summary. You can set the amount of detailing required by setting the tracing level.
    3. Session Detail File – This file contains the load statistics for all the targets in the mappings. It includes information such as table name, number of rows rejected or accepted. To view this file, simply click on the session in monitor window
    4. Performance Detail File – It provides transformation by transformation information on the flow of data through the session. To see this file, you need to select the Performance detail option in the session property sheet
    5. Reject Files – This file contains the rows that the writer does not writes into the target table
    6. Control Files – Control Files and the target files are created by the Informatica Server when you run a session that requires external loader. Control file contains data about the target file such as data format and loading instructor for the external loader. The control file has the extension of .ctl
    7. Post session email – It allows you to automatically communicate information about the session after it runs. So, you can create two different messages, one when the session has executed successfully, the other when it has not
    8. Indicator File – When you use a flat file as a target, you can actually configure the Informatica Server to create an indicator file for target row transformations. The indicator file contains a number to mark whether the row was marked for insert, update, delete or reject for each row of the target file. The informatica server names this file as target_name.lnd and saves it in the same directory as target file
    9. Cache File – When Informatica server creates memory cache it also creates cache files. Informatica server creates cache files for the following transformations in a mapping –
      • Aggregator Transformation
      • Joiner Transformation
      • Rank Transformation
      • Look Up (with cache enabled)

Happy Learning 🙂

,
AvantikaTanubhrt's avatar

Posted by:

AvantikaTanubhrt

I am blogger by chance turned into passion, a businessperson with vision and a data analyst as learner!

Leave a comment