Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 15 Apr 2010 @ 20:57:08 GMT


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


Subj:   Re: Import data from Excel using SQL
 
From:   fachtna.c.donovan

Vinay Bagare wrote:

  If you are using excel 2008, you could potentially have large volume of data.  


  For small data set, I think it is okay to do that but what if you have 1M of rows in the spreadsheet (I guess MS Excel cannot handle that large number itself).  


  You could consider alternate loading paths (Just a thought).  


If you are planning on doing a lot of these sort of imports via MS Excel/Access or any ODBC application you should be careful.

Each row inserted via OBCD will be treated as a single insert statement which will cause you two problems

1) Its going to take a very long time and tie up your PC for the day

2) More importantly is will cause skewing on DBC.AccLogTbl (view dbc.accessLog)

- the Primary Index of DBC.AccLogTbl is (LogonDate,LogonTime)

- every singly insert will have the same logonDate and LogonTime ==> every row will go to the same AMP and cause skewing of DBC.AccLogTbl and potentially cause dbc to run out of space.



     
  <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: 15 Jun 2023