This content has been marked as final. Show 3 replies
There are a number of things...aside from commit interval. Did you check the Informatica Session logs to see where the time is being consumes (Read, Write, Transformation)? Check to see where the time is being spent. If its the the READ, you may have to add custom indexes on the Source System side. Since this is FULL, it will truncate and do a bulk load which is usually fast w the OOTB settings. I would start with the Session loads and then diagnose further.
Pls mark correct or helpful
Ahsan makes some good points. In addition, do you have access to Enterprise Manager? You can monitor the SQLs being run against the source and target (assuming both Oracle DBs) and debug from there. For example, you can take a look at the explain plans to identify if any optimizer hints will give you better performance.
Please mark if helpful/correct,
Few ideas came to mind :
1. This this the longest running task ? Using the DAC are you able to sort the tasks by the 'duration' - do you notice a consistent slow performance across all tasks that has run before this COGS task ?