| ODI Performance issue with flat file [message #612812] |
Fri, 25 April 2014 02:21  |
 |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
