Sunday, March 13, 2011

convert Informatica Session Logs to text/xml format for out of tool readability

There was a situation recently when the infa repository was not able to point us to the old session logs.
However, the file system still had those files.

But the session log files are in binary format by default. If you didnt ask for backward compatible session log files, you'd get a binary format of session log file on file system. This is done to allow better importability of the session log files for infa support guys.

So, I had a few log files in binary format, and needed to analyze them.
Informatica provides a subcommand for infacmd to achieve that conversion.

The convertLogFile subcommand takes three parameters. Syntax is as follows -

convertLogFile <-InputFile|-in> input_file_name
                 [<-Format|-fm> format_TEXT_XML]
                 [<-OutputFile|-lo> output_file_name]

so, when you launch this, you can specify the input file to be converted, the format as TEXT or XML and the output file that you'd want as a result of conversion.

An example call would look like this -  (expecting server on unix) convertLogFile -in /path/to/binary/format/sesslog/file -fm TEXT -lo /my/home/text/format/sesslog/file


  1. Its still possible to use the binary file, if you are on one of unix/linux flavours. Just manage to find a string/pattern that you might be looking for.

    grep will not help a lot since it would come back and say that pattern is found in the binary file. However, if you do more that allows an opportunity for searching using (/)... and that is your saviour...

    gud luck

  2. @Raghav this infacmd command cannot be used from any path except $INFA_HOME/server/bin.Can you suggest some other way

  3. Now you can win free stuff online, free giveaways, enter every day to win latest iphones, smartphones, macbooks, laptops, accessories, technology and much more at iFreeGiveaways - Win Competitions, Freebies & Giveaways Online!

  4. It is really good and motivational topic.I have some urgent essay writing paper work and your post can be very helpful for me.Good to see this link online. webstagram

  5. Maybe the accompanying focuses would help them in understanding the significance of DA, and conquering their own fears:Data Analytics Course

  6. AnyConv is dedicated to helping you transform your songs, videos, images and documents into different formats. provides you to 100% free online file converter tool. Not need to any download and install on your computer, the whole process is online.