When you pay for answers you might get faster response times than 2 hours.
Otherwise answers are voluntary in this forum. And the probability of getting answers will be ower when your unkind.
Did you ever read Oracle's SQL*Loader manuals? You actually considered them to be more easy to understand? Ouch.
There are hardly any books on Teradata (apart from the manuals):
- Tom Coffing's are expensive and mainly a "best of" from the manuals, good for beginners but no advanced stuff
- the books from http://www.cerulium.com/Books.aspx are less expensive, but i never read them
You finally noticed that VARTEXT expects all columns defined as VARCHAR (what they actually are) and there's an automatic typecast to the matching datatype within the target table.
In your case you define 5 fields, but according to the data it's 7 fields and 2679 indicates that 'Smith,Ginny' can't be converted to an INT.
Remove the first and last "|" from the data, because they are separators and before the first and after the last there's no data, so it's a NULL.
+1 (and LOL!)
"we have plan to shift our data from oracle to teradata but it seems to be very difficult becoz there is very fewer help on web."
If you base your choice decissions upon the 'help on the web' instead upon the performance, scalability, etc, well... there you go.
If you find it hard then you can hire a Teradata consultant (which is what I am, btw) instead of reliying on forums and 'good samaritan' advices to solve your (RTFM) problems.
Thanks for help and your proposed solution was correct. and i felt shame why don't check my data source carefully, As you said "pay for answers you might get faster response" you misunderstand me here. i meant to say that Teradata forum is less active as compare to ORacle OTN. it seems that you are the only expert here to help people and i do respect for your voluntry work. moreover, i have read oracle Sql loader manual plenty of time and there are lots of great books which make life more easy to understand the whole concept. That why i have asked about book. And thanks for your recommanded one.
one more think like to ask which i'm currently explorering is FAST LOAD Timestamp fields. i have data in such format. 10:51:32 only time. when i load it table Fast load like 2012-01-01-10:51:32. how can i load simply 10:51:32
Maybe the forum is less active than OTN because TD users need less advice :-)
When you load '10:51:32' into a TIMESTAMP column you should get a row in the ET error table indicating an "invalid timestamp". Could you show the actual script?
When it's a time why don't you use a TIME instead of TIMESTAMP. This is a typical Oracle problem, in TD there's DATE, TIME, TIME WITH TIMEZONE, TIMESTAMP, TIMESTAMP WITH TIMEZONE instead of a DATE (which is a timestamp).
I have a different scenario here.
I get the same error like Adeel, But for a different reason. My source CSV contains data in below format & hence my fastload is unable to process it.
"February 29, 2012","","","","","15/3/2012","22/3/2012","Packaging :: Departure Point :: LON","","15",1,1,0,0.00
"February 29, 2012","","","","","16/5/2012","20/5/2012","Packaging :: Departure Point :: LON","","77",1,1,0,0.00
"February 29, 2012","","","","","19/4/2012","22/4/2012","Packaging :: Departure Point :: LON","","50",0,1,0,0.00
I feel its cause my source data has some quotes. Can you please help me with this?
I/O Error on File Read: 35, Text: EOF encountered before
end of record
I am using Fastload to load some data in to Teradata database from Mainframe
I used the script mentioned below:
.RUN FILE LOGON;
.SET RECORD VARTEXT'|';
BEGIN LOADING PROD_ITC.EMPLOYEE_PROFILE
ERRORFILES PROD_ITC.EMP_ERR1, PROD_ITC.EMP_ERR2
INSERT INTO PROD_ITC.EMPLOYEE_PROFILE VALUES
But I am getting the below error:
.SET RECORD VARTEXT;
**** 04:05:48 FDL4800 Invalid FastLoad statement
04:05:49 Number of recs/msg: 756
04:05:49 Starting to send to RDBMS with record 1
04:05:49 Bad file or data definition.
04:05:49 The length of: EMPLOYEE_NO in row: 1 was greater than
Please provide me some solution to this.
"I am using Fastload to load some data in to Teradata database from Mainframe"
"The SET RECORD command:
• Applies only to network-attached systems."
I am using Fastload to load some data in to Teradata but it returns
No row found for this job in log table SYSADMIN.FASTLOG.
I am having a similar problem in loading fixed width records. Data is simpley not loaded with returned copde = '0' Need some help please...
Please start a new thread for a new question.
With UNFORMATTED you need to declare any end-of-record termination as a field in your DEFINE (which you would not include in the INSERT).
Or since your fixed fields are all character data, use TEXT instead.