50 - 71 of 71 tags for fastload

Pages

What is the data format using by TPT\Fastload while primary transfer to Teradata instance?

We using Fixed-width source-files for fasload - its a really excessive data (higly compressible).

Does Fastload (or TPT) use a custom format for transmission to the lower coefficient of redundancy,

I'm finding an issue I'm having with a Fastload job and a text file with pretty standard dates extremely maddening, and I am sure V12/V13 has changed Fastload's behaviour in some way, as I'm sure what I am trying to do was not this difficult before.

Consider a few rows of the tab-delimited text file:

I need to load numerous flat files using FastLoad.  Is it possible to loop through the file names in FastLoad so I don’t have to change the file name for each data file that needs to be loaded in the FastLoad script?

For example:

From a high level, what be the major differences between PT API & Fastload?
Does PT API internally use Fastload OR is it a completely new System?

Hi there,

Could anybody help me to look at this? Thanks in advance!

I met some problems when I use fastload:

Error messages:
Fastload: Incorrect number of bytes returned from a File Read

fast export script:

.logtable DP_DEDW_MDB.XM_ACCOUNT_LOAD_LOG;
.LOGON 11.11.11.1/user,pass;

.begin export sessions 8;
.export outfile fast.out mode record format fastload;

select
trim(TRAILING '0D'XC FROM trim(TRAILING '0A'XC from TRIM(coalesce (cast (feed as VARCHAR(50)) ,''))))|| '|' ||

Hi,
I am running the following fastload script to read from a csv file:

SHOW VERSION ;
SESSIONS 4;
ERRLIMIT 2000;

logon tdpid/username,password;

drop table DBNAME.Bday_reminder ;

create table DBNAME.Bday_reminder (
First_Name VARCHAR(50),
Last_Name VARCHAR(50),
Mail_Id VARCHAR(50),
Emp_id INTEGER,
Extn_No INTEGER,
Mobile_No INTEGER,
Mobile_No_Home INTEGER
)
PRIMARY INDEX Bday_reminder ( Emp_id );

SET RECORD vartext " ";

define

First_Name (VARCHAR(50)) ,
Last_Name (VARCHAR(50)),
Mail_Id (VARCHAR(50)),

Hi,

For an mistake, i´m run fastload with a erroneous file input name, then fastload give me an string error, but the RETURN CODE was 0.

The return code not will be great then zero ?

Regards.

Hi,
I am executing a fastlaod script which is as follows:

SESSIONS 4;
ERRLIMIT 2000;
.logon tdpid/username,password;

create table DBNAME.id_unit_fload (
id VARCHAR(18),
units VARCHAR(18)
)
PRIMARY INDEX UPI_id_unit_fload ( id );

SET RECORD UNFORMATTED;

define

id (VARCHAR(18)),
units (VARCHAR(18))

file=insert.input;

SHOW;

BEGIN LOADING DBNAME.id_unit_fload errorfiles DBNAME.err_1, DBNAME.err_2;

insert into DBNAME.id_unit_fload
(
:id,
:units
);

END LOADING;

logoff;

ouput report :

A Total Records Read = 35000
B Total ErrorTable 1 = 1250 (Not loaded due to error)
C Total ErrorTable 2 = 30 (Duplicate UPIs only)
D Total Inserts Applied = 33700
E Total Duplicate Rows = 20

Hello everyone,

I am new to teradata and I am trying to upload a file using fast load.
When I run the batch file I get the following error in the log file:

Not enough fields in vartext data record number: 1

In the teradata table, I have varchar (100) for all the colums, so not sure what is going on.

My script is the following:

sessions 1;
errlimit 10;
logon DWSANA/username,password;

set record vartext;
begin loading D_CFAEISDB.FTP_profile_fl01 errorfiles d_cfaeisdb.Err1,d_cfaeisdb.Err2;
RECORD 1;
DEFINE FILE=\\is-m-54lxx-fs12\DBP_PLANNING\Fast Load\FTP profile.txt;

While loading rows into a table, FastLoad displays, by default, an output message for every 100,000 rows loaded,  for example:

**** 14:47:20 Starting row 100000
**** 14:47:21 Starting row 200000
**** 14:47:22 Starting row 300000
...

If the number of rows being loaded is less than 100,000, FastLoad will not output any of these messages.

These messages are used as heartbeats that indicate that FastLoad is working for a long running job.

That was fine for jobs decades ago, however, for today's jobs where millions (and even billions) of rows are being loaded this much output may not be sensible. Can we imagine what the console output would look like with the default output message rate of every 100,000 rows?

Hi,

Can some one provide me the link to Teradata Load utilities for linux download location. I have searched the download center extensively with no result. I would like to install BTEQ,FASTLOAD,MULTILOAD,TPUMP utilites on linux box.

Thanks

This presentation describes, in detail, the various load utilities supported by Teradata.

I have been asked by the server admins to provide a space requirement to install the following Teradata 12 utilities on a SUN Solaris SPARC server:

(1) CLI and related security libraries
(2) BTEQ
(3) FastLoad
(4) MultiLoad
(5) FastExport

This book provides information on how to use Teradata Parallel Transporter (Teradata PT), an object-oriented client application that provides scalable, high-speed, parallel data extraction, loading, and updating. These capabilities can be extended with customizations or third-party products.

This book provides information on how to use the Teradata Parallel Transporter (Teradata PT) Application Programming Interface. There are instructions on how to set up the interface, adding checkpoint and restart, error reporting, and code examples.

This book provides reference information about the components of Teradata Parallel Transporter (Teradata PT), an object-oriented client application that provides scalable, high-speed, parallel data extraction, loading, and updating. These capabilities can be extended with customizations or with third-party products.

In the first article in this series on Teradata Error Handling, we introduced the larger architecture and load utility environment. in this article the focus will be on the Fastload Utility and some of the techniques applicable to handling errors, exceptions and failures that can occur within a High Availability system.

This book provides reference information about the components of Teradata Parallel Transporter (Teradata PT), an object-oriented client application that provides scalable, high-speed, parallel data extraction, loading, and updating. These capabilities can be extended with customizations or with third-party products.

A high-availability system must have the ability to identify and correct errors, exceptions and failures in a timely and reliable manner to meet challenging service level objectives. The Teradata database and the utilities and components (used to both load and access data) provide capabilities to implement reliable error and exception handling functionality. These capabilities combined with a well designed high availability architecture allow a Teradata Active Enterprise Intelligence (AEI) system to meet the service level objectives required to support mission critical business processes.

Please note:  This content does not apply for sites on Teradata 13.10 or later releases.