Archives of the TeradataForum
Message Posted: Wed, 10 Mar 2004 @ 21:03:47 GMT
| Subj: || || Re: Cognos Cube Builds from Teradata |
| From: || || Ferry, Craig |
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.