What is tracing level and what are the types of tracing
level?
- 2 Answers
- 36791 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sekhar
If u observe in the mapping for every trarsformation has
the property Tracing Level and it means The amount of
detail in the session log depends on the tracing level that
you set.
Normal: PowerCenter Server 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.
Verbose Initilization: In addition to Normal tracing, the
session log file contains names of index and data files
used,and detail transformation information statics.
Verbose data: In additon to verbose intitialigation, Power
centre server logs each row that passing through mapping.
Terse: PowerCenter Server logs initialization information
as well as error messages and notification of rejected data
| Is This Answer Correct ? | 85 Yes | 3 No |
Tracing Level -Amount of detail in Session Log.
Four Types:
Normal
Terse
Verbose Intialization
Verbose Data
| Is This Answer Correct ? | 31 Yes | 6 No |
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
can we override a native sql query within informatica? How do we do it?
How the informatica server increases the session performance through partitioning the source?
What is metadata reporter?
Have you worked with/created Parameter file
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
How will you check the bottle necks in informatica? From where do you start checking?
How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
What are the databases that informatica can connect to windows?
HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com
Teradata 
