Archives of the TeradataForum

Message Posted: Wed, 10 Mar 2004 @ 21:03:47 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I build a cube a few times a month which uses about 28 million rows in a td table. It takes me approximately 3 to 4 hours to build. There are several tuning things you can do to speed up the build, but one thing I would check is your Maximum Response Buffer Size in your ODBC connection. I have mine set to 65477 (which I believe is the max).

Other things that will impact your response time are how you are building the cube. One of the biggest things I found in how fast the data goes into the cube is if you are checking for duplicates using the transformer tool or do it ahead of time via GROUP BY in teradata. I do mine on the teradata side.

Craig

	<Prev	Next>		<<First	<Prev	Next>	Last>>