How to identify bottlenecks in
sources,targets,mappings,workflow,system and how to
increase the performance?
- 4 Answers
- 34356 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 many number of sessions can one group in batches?
what is the Default Source Option For Update Strategy Transformation?
Please let me know how to make encryption and decryption with example?
Explian the Process of deployment groups in informatica
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What do you mean by filter transformation?
Slowly changing dimensions, types and where will you use them
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Different qualification between a related rotate toward the sky and isolates look upward?
What are data-driven sessions?
How will the document be delivered to me?
What are the different clients of powercenter?
What is a passive transformation?
Explain constraint based loading in informatica
What is the difference between writing a joiner query in ANSI style and THETA style?
