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
- 35426 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 load dimension table and fact table. plz tell me the steps.
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?
Explain what are the different types of transformation available in informatica.
Explian the Process of deployment groups in informatica
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What are the tasks that can be performed using sq?
What is meant by pre and post session shell command?
How can you generate reports in informatica?
What is data transformation manager process?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Explain the pipeline partition with real time example?
What is a joiner transformation?
What is xml source qualifier transformation in informatica?
scenario where i can use only concurrent execution of workflow.
How you can differentiate between connected lookup and unconnected lookup?
