what is tha tracesing level? and difference betweentrace in
normal and verbose and nonverbose?
Answers were Sorted based on User's Feedback
Answer / dilip
This is a kind of explanation when a session log is created....
Normal : It explains in a detailed maner
Verbose: It explains detailed explanation for each and every
row
For more explanation please refer to the Docs....in Informatica
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / gp
Tracing level means the amount of data storing in to the
log files.
Tracing Levels are TERSE,VERBOSE,VERBOSE INTIALIZATIO and
NORMAL
| Is This Answer Correct ? | 0 Yes | 1 No |
What is Index Caches size?
list out all the transformations which use cache?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are active transformations? Name them.
what is Partitioning ? where we can use Partition?
Design a mapping to load a target table with the following values from the above source?
In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?
What is the difference between normal and bulk loading? Which one is recommended?
What is dimensional table? Explain the different dimensions.
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
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?
What is the status code in stored procedure transformation?