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
- 35283 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
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Clarify the utilization of aggregator cache record?
How an expression transformation differs from aggregator transformation?
What are the differences between oltp and olap?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Write the unconnected lookup syntax and how to return more than one column.
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are active and passive transformations?
What are the various types of transformation?
Define Pmrep command?
what is mean by complex business rule ?
Tell me about Propagate functions in informatica
Write the prerequisite tasks to achieve the session partition?
Can we override a native sql query within informatica?
Explain the mapping variable usage example in informatica
