Features of Fastload with examples

Fast-load has the following features: 

Important observations:

1. We can load both SET and MULTISET tables using Fastload


2. Fastload supports Primary Index (both PI and UPI). Teradata Fastload does not support join indexes, foreign key references in target tables and tables with secondary index defined. It is necessary to drop any of the constraints listed before loading and recreate them afterwards.
3. If duplicate records are present in the source file, and we are loading a MULTISET table, the duplicates will be silently dropped, since fastload does not support duplicates.


For data :
mathew|19111987
karan|24121987
gaurav|24101986
gaurav|24101986
Data loaded in table is:

NAME	DOB
Mathew	19/11/1987
Gaurav	24/10/1986
Karan	24/12/1987

**** 07:28:21 END LOADING COMPLETE
Total Records Read = 4
Total Error Table 1 = 0 ---- Table has been dropped
Total Error Table 2 = 0 ---- Table has been dropped
Total Inserts Applied = 3
Total Duplicate Rows = 1
We get the above report at the end of loading.
4. If we define a delimiter, then FLD expects VARCHAR, VARBYTE only in the .DEFINE layout definition.


**** 07:28:17 Now set to read 'Variable-Length Text' records
**** 07:28:17 Delimiter character(s) is set to '|'
5. If dates are present in the input file, then load using


0015 INSERT INTO tl_62917_dly1_qrmdb.fld1
VALUES
(
:NAME,
:DOB(date, format 'ddmmyyyy')
);

Please note that the date format is for  the DATE format in the INPUT file.



6. If FLD fails due to data errors, then to find the records that failed, perform the following steps:

Total Records Read = 4

Total Error Table 1 = 3

Total Error Table 2 = 0 ---- Table has been dropped

Total Inserts Applied = 0

Total Duplicate Rows = 1

Write a bteq :

.logon server1/user1,mar@2012;

.export data file=fastload_error.txt

select trim(dataparcel) from TL_62917_DLY1_QRMDB.FLD1_ET;

.logoff

The DataParcel column in _ET table is LOV, so it can only be read if the export file is DATA

You can revert back with your queries, if any.