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 |
how to create a sample mapping for dynamic lookup transformation
can a port in expression transf be given the name DISTINCT
i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
Sequence generator, when you move from develoment to production how will you reset
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
In ur current projectu have done any performance tuning of mappings?
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
where actually the usage of push down optimization happens...
How might you approve all mappings in the archive all the while?
How to load duplicate records in to a target table which has a primary key?
what are the unix commands to start the wrk flow ?