Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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.


Craig



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019