Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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--
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.