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 |
How the dimensions will be loaded?
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
Write the program through which the records can be updated?
What is a code page?
Can u generate reports in Informatica?
Informatica settings are available in which file?
in which situations do u go for scds ?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
how to load rows into fact table in data warehouse
What are Dimensional table?
what are the different types of transformation available in informatica and what are the mostly used ?
When the informatica server marks that a batch is failed?