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 |
Where are the source flat files kept before running the session?
empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.
how to obtain performance data for individual transformations.
How to join three sources using joiner? Explain though mapping flow.
What is a rank transform?
What is a repository? And how to add it in an informatica client?
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
can every transfomation reusable?how?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
how can we use sorter transformation in joins?