Home » RDBMS Server » Performance Tuning » ODI Performance issue with flat file (ODI 11g )
ODI Performance issue with flat file [message #612812] Fri, 25 April 2014 02:21 Go to next message
Messages: 2
Registered: March 2011
Junior Member

It would be great full if any one could help me on the below issue.

I am using ODI 11g to pull the Flat file from SQL server to Netezza database.

When pulling the flat file to Staging table (Netezza), in the step, Load to staging area it is taking 1 hour 30 mins appx to pull 650000 records.

It is full load. I am sure for pulling 650000 records ,it takes max 10-15 mins.

Is there any way that i could minimize the execution time? Eg: by increasing the buffer size in ODI etc...

Re: ODI Performance issue with flat file [message #612825 is a reply to message #612812] Fri, 25 April 2014 07:35 Go to previous message
Messages: 25856
Registered: January 2009
Location: SoCal
Senior Member
where is actual time being spent?
Previous Topic: performance imapct on stats collection
Next Topic: performance Tuning
Goto Forum:

Current Time: Thu Feb 22 14:50:26 CST 2018

Total time taken to generate the page: 0.02742 seconds