Interested to Buy Any Domain ? << Click Here >> for more details...
What is tracing level and what are the types of tracing
level?
- 2 Answers
- 38273 Views
- TCS, I also Faced
- E-Mail Answers
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 |
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
What are events in workflow manager?
How to eliminate duplicate records in informatica mapping? Explain with an example....
How will you convert rows into columns or columns into rows
what is bridge tables in informatica
What is limitations of truncate and load option
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
What is batch and describe about types of batches?
what is $$$$?
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
Teradata 
