What is tracing level and what are the types of tracing
level?

Answers were Sorted based on User's Feedback



What is tracing level and what are the types of tracing level? ..

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

What is tracing level and what are the types of tracing level? ..

Answer / nathan vaithi

Tracing Level -Amount of detail in Session Log.

Four Types:

Normal
Terse
Verbose Intialization
Verbose Data

Is This Answer Correct ?    31 Yes 6 No

Post New Answer

More Informatica Interview Questions

SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?

6 Answers   IBM,


What are the uses of a Parameter file?

3 Answers   CSC,


differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??

2 Answers   IBM,


Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,


What is Factless fact table ???

12 Answers   Satyam, Tech Mahindra,






How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,


Explain the different kinds of facts.

0 Answers  


If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 Answers  


My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

3 Answers   Cap Gemini,


What is difference between a gateway node and worker node?

0 Answers  


What is mapplet in informatica?

0 Answers  


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  


Categories