How to identify bottlenecks in
sources,targets,mappings,workflow,system and how to
increase the performance?
Answer Posted / srinu
identification of bottelnecks
target:configuring session to write to flatfiletarget
source:add filter t/r after sq t/t to false show that no
data is processed past the filter t/r,if it time takes to
run new session remains same to the original session there
is source bottel necks
mapping:add filter t/f before each target and set filter
condition to false,similar to source
session:use the collect performance data to identify the
session bottel necks
read from desk,write to disk counters other than zero,there
is bottelnecks
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
Informatica Checkpoints
Briefly explain the aggregator transformation?
Explain sessions?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Why update strategy and union transformations are active?
what is the -ve test case in your project.
What is session task and command task?
What is a repository? And how to add it in an informatica client?
What is complex mapping?
How can we delete duplicate rows from flat files?
What is option by which we can run all the sessions in a batch simultaneously?
What is the use of target designer?
can we override a native sql query within informatica? Where do we do it? How do we do it?
can you please explain me pre session and post session options?
What are data-driven sessions?