Sunday, October 16, 2011

Session Log In Text/XML

Hi all,
I have a Small Requeirment,I.e I want to see my Session Logs in Text Format.To Achive this we have two Methods in Informatica.
But the session log files are in binary format by default. If you don't ask for backward compatible session log files, you'd get a binary format of session log file on file system.
1.Go to
Session Properties-->General Options-->Write Backward Compatible Session Log File
Check this option,Then You will get that particular Session Log in Text format.

Before Setting This Option,



After Setting This Option,



2. I want to use infacmd convertLogFile utility to convert it.
Actually
convertLogFile Subcommand takes 3 Arguments.The Syntax Will be........
convertLogFile <-InputFile|-in> input_file_name
[<-Format|-fm> format_TEXT_XML]
[<-OutputFile|-lo> output_file_name]

The Following One is a Simple Example.
convertLogFile -in D:\Server9\server\infa_shared\SessLogs\s_M_LKP_FIL.log.bin -fm XML -lo D:\Server9\server\infa_shared\SessLogs\s_M_LKP_FIL.xml









   The Infacmd Programs Indicates The Success Or Failure of  a Command With the Following Return Codes.
         A. 0---->Success
         B. 1---->Failure



No comments:

Post a Comment