Tracing level in Informatica tells the level of detail about the transformation that the Integration Service writes into the session log. There are four types of tracing levels in Informatica Sequence Transformation –
-
- Terse – This level of tracing logs initialization information, error messages and notification of rejected data in the session log file.
-
- Normal – It logs the following —
-
- Initialization and status information
-
- Errors encountered and skipped rows due to transformation row errors
-
- Summarizes session results, although not at the level of individual rows
-
- Normal – It logs the following —
-
- Verbose Initialization – This tracing level apart from tracing the Normal, also does the following –
-
-
- Additional initialization details
-
-
-
- Name of index and data files used
-
-
-
- Details transformation statistics
-
-
- Verbose Data – This tracing level in addition to verbose initialization does the following –
- It logs each row that passes into the mapping.
- Verbose Data – This tracing level in addition to verbose initialization does the following –
-
-
- It notes where the integration service truncates string data to fit the precision of a column and provides detailed transformation statistics.
-
-
- It writes row data for all rows in a block when it processes a transformation
If you have any queries comment below 🙂
Happy Learning 🙂

Leave a comment