ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Data Warehouse >> Informatica
 
 


 

 
 Teradata interview questions  Teradata Interview Questions (183)
 Business Objects interview questions  Business Objects Interview Questions (751)
 Cognos interview questions  Cognos Interview Questions (842)
 Informatica interview questions  Informatica Interview Questions (1622)
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions (29)
 Actuate interview questions  Actuate Interview Questions (35)
 Ab Initio interview questions  Ab Initio Interview Questions (168)
 Data Stage interview questions  Data Stage Interview Questions (563)
 SAS interview questions  SAS Interview Questions (551)
 Micro Strategy interview questions  Micro Strategy Interview Questions (36)
 ETL interview questions  ETL Interview Questions (195)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (215)
Question
What aer the out put files that the informatica server
creates during the session running?
 Question Submitted By :: Informatica
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
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 ?    5 Yes 0 No
Swetha
 
Answer
# 2
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
Sam
 
 
 
Answer
# 3
Check the backward compatibility option to view the .bin
log files in readble format.
 
Is This Answer Correct ?    2 Yes 2 No
Bzz
 
Answer
# 4
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
Rahul
 

 
 
 
Other Informatica Interview Questions
 
  Question Asked @ Answers
 
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance   3
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ? IBM 6
where does the default group roew in a router is stored what is the default size of memory in router   1
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance, Tech-Mahindra 6
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic Deloitte 20
How could we generate the sequence of key values without using sequence generator transformation in the target ?? Tech-Mahindra 12
what is polling?   1
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how? Patni 4
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000 Deloitte 6
In joiner, how to load Master table in Target?   2
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query Cap-Gemini 8
What is the procedure to load the fact table.Give in detail?   1
 
For more Informatica Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com