Re: ETL tool configuration

From: "Farmer, Byrd G - CFC" <Farmer.Byrd@cfwy.com> > >We are using Informatica as out ETL tool to load data into the warehouse. Sucker! :-) >The Informix engine is 7.24 UC3. We are only getting 25-30 rows a second >processing through Informatica. Theire tech support was here yesterday and >said that the write preformance in Informix was too low. However I can >load >10,000 rows a second using HPL, so I am not sure they are right. Does >anyone out there have any suggestions on what parameters I might try to >improve the speed of the Informatica load? We are in the process of trying >to upgrade Informatica from 4.14 to 4.60 now and this would be a good time >to make any changes to the engine. Thanks for any help you can give. How about you post us your onconfig, onstat -d and onstat -D? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com