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

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

Answer / bzz

Check the backward compatibility option to view the .bin
log files in readble format.

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.

Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers  

---

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

---

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

---

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,

---

What is the difference between a table and the materialized view?

2 Answers  

---

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,

---

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  

---

What do you understand by SOA of Informatica?

0 Answers  

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,

---

Does an informatica transformation support only aggregate expressions?

0 Answers  

---

Define Incremental Aggregation?

2 Answers  

---

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,

---