SAURABH2301

 Profile Answers by SAURABH2301 

• Oct 24th, 2009

 

I guess you are asking about the tracing level.  When you configure a
transformation, you can set the amount of detail the Integration Service writes
in the session log.  PowerCenter 8.x supports 4 types of tracing level:

1.Normal: Integration Service logs initialization and status information,
errors encountered, and skipped rows due to transformation row errors.
Summarizes session results, but not at the level of individual rows.

2.Terse: Integration Service logs initialization information and error
messages and notification of rejected data.

3. Verbose Initialization: In addition to normal tracing, Integration Service
logs additional initialization details, names of index and data files used, and
detailed transformation statistics.

4.Verbose Data: In addition to verbose initialization tracing, Integration
Service logs each row that passes into the mapping. Also notes where the
Integration Service truncates string data to fit the precision of a column and
provides detailed transformation statistics.
Allows the Integration Service to write errors to both the session log and error
log when you enable row error logging.
When you configure the tracing level to verbose data, the Integration Service
writes row data for all rows in a block when it processes a transformation.

By default, the tracing level for every transformation is Normal.

SAURABH2301

 Profile Answers by SAURABH2301 

• Oct 24th, 2009

 

Also for efficient & faster depends on your requirement.
If you want minimum information to be written to the session logs you can use the Terse tracing level.

From Informatica Transformation Guide:
"To add a slight performance boost, you can also set the tracing level to Terse, writing the minimum of detail to the session log when running a workflow containing the transformation"

Hope the answers help.

Regards,
Saurabh