Database Reference
In-Depth Information
Tracing levels
Tracing levels in Informatica define the amount of data you wish to write in the session log
when you execute the workflow. The tracing level is a very important aspect of Informat-
ica, as it helps in analyzing errors. It is also very helpful in finding the bugs in the process
and you can define it in every transformation. The tracing level option is present in every
transformation properties window. There are four types of tracing levels available:
•
Normal
: When you set the tracing level as
Normal
, Informatica stores the status
information, information about errors, and information about skipped rows. You
get detailed information but not at an individual row level.
•
Terse
: When you set the tracing level as
Terse
, Informatica stores the error inform-
ation and the information of rejected records.
Terse
tracing level occupies less
space than
Normal
.
•
Verbose Initialization
: When you set the tracing level as
Verbose Initialize
, it
stores the process details related to the startup, details about index, data files cre-
ated, and more details of the transformation process in addition to details stored in
the normal tracing. This tracing level takes more space than
Normal
and
Terse
.
•
Verbose Data
: This is the most detailed level of tracing. It occupies more space
and takes more time than the other three levels. It stores row-level data in the ses-
sion log. It writes the truncation information whenever it truncates the data. It also
writes the data to the error log if you enable row-error logging.
The default tracing level is
Normal
. You can change the tracing level to
Terse
in order to
enhance performance. The tracing level can be defined at an individual transformation
level, or you can override the tracing level by defining it at the session level.
