Import Tab delimited file through Teradata fast load utility is not working.
,
24 Feb 2016
| 4 comments
I am facing an issue in executing below scritp through fast load utility for tab delimited .txt file.
1. First issue in .RECORD 1;
Fast load stuck after logon
,
27 Apr 2015
Hi there,
I have run a fastload script, however it's stuck on below step. Any idea what's the possible reasons? Thank you.
**** 09:24:27 Teradata Database Release: 14.10.04.04
**** 09:24:27 Teradata Database Version: 14.10.04.04
**** 09:24:27 Number of AMPs available: 336
Issues with loading date field using BTEQ script
,
25 Jul 2014
| 1 comment
Hi Guys,
I'm pretty new to BTEQ script. I was trying to load a table which has a date column but it's not being inserted properly.
I'm using the below code, this loads the data but the date column loads a s a float and not as a date field.
issue in fast load with algorithmic compression
,
10 Jan 2014
| 1 comment
Hi Guys,
I am doing fast load to an empty table which has one column with algorithmic compression (ALC) using TransUnicodeToUTF8. Below is my table structure.
CREATE MULTISET TABLE SCPLN_W.SAMPLE1, NO FALLBACK
(
C1 VARCHAR(1) NOT NULL,
Performance tuning of a Fast Load Script-
,
19 Oct 2013
| 5 comments
Hi All,
One way to tune a fast load script is by increasing the number of sessions ,which fast load will use for loading the data ,but also dependent
on the number of available sessions.
Can you please suggest by various other approaches by which a fastload script can be tuned ?
Executing FastLoad Protocol on TPT with Flat files with VARIABLE COLUMN NUMBERS
,
04 Jul 2013
| 1 comment
Hello Everyone,
I've been learning TPT and have been given various scenarios to execute; specifically ones that deal with the FAST LOAD protocol. There is one scenario that I am having issues trying to figure out, which is as follows:
TARGET TABLE has N columns.
Fast load
,
15 Jun 2013
| 1 comment
hi,
Please help me for below script.
clear;
sessions 10;
tenacity 4;
sleep 20;
DATEFORM ANSIDATE;
show version;
.LOGON 127.0.0.1/TDUSER, TDUSER
DROP TABLE tduser.M1;
DROP TABLE TDUSER.ERR1;
DROP TABLE TDUSER.ERR2;
Types of locks during Fastload abort-?
,
28 May 2013
| 13 comments
Hi All,
Have a doubt in my mind, just want to clear it regarding the types of locks applied during fast load abort case and why is it different from that of multiload
Teradata Lead / Developer
,
28 Jun 2012
| 2 comments
Teradata Lead / Developer
Experience from 3 to 10 years
BTEQ or Fast Load or Multi Load
,
11 Mar 2012
Hi everyone! I am currently studying Teradata and currently working on this problem of mine. You see, i have this set of data on a flat file that needs to be loaded in a table based on a condition.
This is what my flat file looks like:
##Flatfile
SOR|03/17/2012|2 -- This is a header