Tags for fast load
Import Tab delimited file through Teradata fast load utility is not working.
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 teradata scripts
Fast load stuck after logon
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
fast load
Issues with loading date field using BTEQ script
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.
bteq fast load
issue in fast load with algorithmic compression
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,
fast load alc algorithmic compression transunicodetoutf8
Performance tuning of a Fast Load Script-
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 ?      
fast load performance tuning.
Executing FastLoad Protocol on TPT with Flat files with VARIABLE COLUMN NUMBERS
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.
tpt Flat Files fast load
Fast load
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;
fast load
Types of locks during Fastload abort-?
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
fast load multiload utility
BTEQ or Fast Load or Multi Load
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
teradata dml bteq update insert mload fast load delete row column file data staging table upsert header

Pages