ETL tool configuration
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFA0A1.F81E7E30 Content-Type: text/plain; charset="iso-8859-1" We are using Informatica as out ETL tool to load data into the warehouse. 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. ------_=_NextPart_001_01BFA0A1.F81E7E30 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2651.75"> <TITLE>ETL tool configuration</TITLE> </HEAD> <BODY> <P><FONT COLOR=3D"#000080" SIZE=3D2 FACE=3D"Courier New">We are using = Informatica as out ETL tool to load data into the warehouse. 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.</FONT></P> </BODY> </HTML> ------_=_NextPart_001_01BFA0A1.F81E7E30--