What is tracing level and what are the types of tracing
level?
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 |
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
How the Informatica Server reads perameter file?
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
what are the output files that the informatica server creats during running a session?
Is informatica power center designer has 64 bit support?
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
How many mapplets u have created? and what is the logic used
How does a rank transform differ from aggregator transform functions max and min?
can every transfomation reusable?how?
How do you remove duplicate records in informatica?