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 |
What are the designer tools for creating transformations?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
What is power play plug in?
What are the components of workflow manager?
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
What are reusable transformations in how many ways we can create them?
in oracle write query yourname+1 from dual
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
Explain Dataware house architecture .how data flow from intial to end?
i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.