Interested to Buy Any Domain ? << Click Here >> for more details...
How to identify bottlenecks in
sources,targets,mappings,workflow,system and how to
increase the performance?
- 4 Answers
- 35631 Views
- I also Faced
- E-Mail Answers
Answer Posted / samba ch
Bottleneck in Informatica
Bottleneck in ETL Processing is the point by which the performance of the ETL Process is slowr.
When ETL Process is in progress first thing login to workflow monitor and observe performance statistic. I.e. observe processing rows per second. In SSIS and Datastage when you run the job you can see at every level how many rows per second is processed by the server.
Mostly bottleneck occurs at source qualifier during fetching data from source joiner aggregator Lookup Cache Building Session.
Removing bottleneck is performance tuning.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to join three sources using joiner?
How to create a non-reusable instance of reusable transformations?
Why do we need informatica?
what is $$$$?
What is the difference between informatica 7.0 and 8.0?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Explain pushdown optimization $pushdownconfig parameter - informatica
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What are the types of lookup transformation?
How to configure mapping in informatica?
Explain lookup transformation is active in informatica
What do you understand by SOA of Informatica?
In informatics server which files are created during the session rums?
can anyone suggest best free Talend data integration training online
In informatica workflow manager, how many repositories can be created?
