Archives of the TeradataForum
Message Posted: Thu, 15 Apr 2010 @ 20:57:08 GMT
| 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.
| 
