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
giridhar123
Messages: 2
Registered: March 2011
Junior Member
Hello,

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...

Regards
Giridhar.
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
BlackSwan
Messages: 22802
Registered: January 2009
Senior Member
where is actual time being spent?
Why not use EXTERNAL TABLE?
Previous Topic: performance imapct on stats collection
Next Topic: performance Tuning
Goto Forum:
  


Current Time: Tue Sep 23 07:46:27 CDT 2014

Total time taken to generate the page: 0.07267 seconds