Interested to Buy Any Domain ? << Click Here >> for more details...
What aer the out put files that the informatica server
creates during the session running?
- 4 Answers
- 19618 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha
Informatica server log: Informatica server(on unix) creates
a log for all status and error messages (default name:
pm.server.log). It also creates an error log for error
messages. These files will be created in informatica home
directory.
Session log file: Informatica server creates session log
file for each session. It writes information about session
into log files such as initialization process, creation of
sql commands for reader and writer threads, errors
encountered and load summary. The amount of detail in
session log file depends on the tracing level that you set.
Session detail file: This file contains load statistics for
each targets in mapping. Session detail include information
such as table name,number of rows written or rejected. yoU
can view this file by double clicking on the session in
monitor window
Performance detail file: This file contains information
known as session performance details which helps yoU where
performance can be improved. To genarate this file select
the performance detail option in the session property sheet.
Reject file: This file contains the rows of data that the
writer does not write to targets.
Control file: Informatica server creates control file and a
target file when yoU run a session that uses the external
loader. The control file contains the information about the
target flat file such as data format and loading instructios
for the external loader.
Post session email: Post session email allows yoU to
automatically communicate information about a session run to
designated recipents. U can create two different
messages.One if the session completed sucessfully the other
if the session fails.
Indicator file: If u use the flat file as a target,yoU can
configure the informatica server to create indicator file.
For each target row, the indicator file contains a number to
indicate whether the row was marked for insert, update,
delete or reject.
output file: If session writes to a target file,the
informatica server creates the target file based on file
prpoerties entered in the session property sheet.
Cache files: When the informatica server creates memory
cache it also creates cache files. For the following
circumstances informatica server creates index and datacache
files.
Aggreagtor transformation
Joiner transformation
Rank transformation
Lookup transformation
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sam
Run the infacmd ConvertLogFile -in <inputfilename> -lo
<outputfilename>. This batch file is present in
\\Informatica\PowerCenter8.6.1\CMD_Utilities\PC\server\bin
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / bzz
Check the backward compatibility option to view the .bin
log files in readble format.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / rahul
i am getting these session log file in .bin format but i
want it in text format.how can i get it??
i am using informatica 8.5.1 with windows on client and
server both.
| Is This Answer Correct ? | 0 Yes | 3 No |
What are Dimensional table?
hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???
what is the size of u r source(like file or table)?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is sequence generator transformation in informatica?
write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
can we use cartesian join in informatica
In ur current projectu have done any performance tuning of mappings?
how to load dimension table and fact table. plz tell me the steps.
Please let me know how to make encryption and decryption with example?
Teradata 
