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
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