Because it locks at this level,and not at the table level like MultiLoad,TPump can make many simultaneous, or concurrent, updates on a table.
TPump performs Inserts,Upadtes,Deletes and Upserts from Flat filed to populated Teradata tables at ROW LEVEL.
- Secondary Indexes
- Referential Integrity
- Join indexes
- Pumpdata in at varying rates.
Tpump also have limitations.
- No concatenation of input data files is allowed.
- TPump will not process aggregates, arithmetic functions or exponentiation.
- The use of the SELECT function is not allowed.
- No more than four IMPORT commands may be used in a single load task.
- Dates before 1900 or after 1999 must be represented by the yyyy format for the year portion of the date, not the default format of yy.
- On some network attached systems, the maximum file size when using TPump is 2GB.
- TPump performance will be diminished if Access Logging is used.
Tpump supports One Error Table.The error table does the following:
- Identifies errors
- Provides some detail about the errors
- Stores a portion the actual offending row for debugging
A Sample TPump Script
- The script on the following page follows these steps:
- Setting up a Logtable
- Logging onto Teradata
- Identifying the Target, Work and Error tables
- Defining the INPUT flat file
- Defining the DML activities to occur
- Naming the IMPORT file
- Telling TPump to use a particular LAYOUT
- Telling the system to start loading
- Finishing and log off of Teradata
ERROR TABLE EMPDB.TPUMP ERROR;
.FIELD EMP_NUM * INTEGER;
.FIELD DEPT_NUM * SMALLINT;
.FIELD FIRST_NAME * CHAR(20);
.FIELD LAST_NAME * VARCHAR(20);
.FIELD SALARY * DECIMAL(8,2);
.DML LABEL EMP_INS;
INSERT INTO EMPDB.EMP_TABLE
(EMP_NUM, DEPT_NUM, FIRST_NAME, LAST_NAME, SALARY)
(:EMP_NUM, :DEPT_NUM, :FIRST_NAME, :LAST_NAME, :SALARY);
.IMPORT INFILE C:\TEMP\TPUMP_FLAT_FILE.txt;