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
- 35481 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
What is the reusable transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Is it possible to define a single node as a Gateway node as well as worker node?
What is rank transformation in informatica
How you know when to use a static cache and dynamic cache in lookup transformation?
What is informatica metadata and where is it stored?
What are the types of presistent cache in look up tr.
What the difference is between a database, a data warehouse and a data mart?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
what is the complex transformation you used in informatica
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Name the different lookup cache(s)?
I have a flat file, want to reverse the contents of the flat file
What is an unconnected transformation?
