Table properties and utilities to load data

Teradata Applications

Table properties and utilities to load data

How Data Block size, checksum & Perm DB size of a target table play a role when loading Bulk data using Fast Load and Transactional Loading like TPUMP or BTEQ file load?

Basically I am trying to understand, How a table should be designed based on the Load utilities that is going to be used.

4 REPLIES
Teradata Employee

Re: Table properties and utilities to load data

I dont think these attributes will have any significant impact on loading times. Bulk load through FastLoad or TPT is always going to give you far better performance as compared to other methods.

Enthusiast

Re: Table properties and utilities to load data

This is a good read on checksum.

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1093_111...

I have not experimented with various settings and loads.

Re: Table properties and utilities to load data

Can you please sombody explain me why we cant load data into teradata table from another using Mload/Fload?

Senior Apprentice

Re: Table properties and utilities to load data

The load utilities are used to load data which doesn't exists yet within the system

If the data is already in a TD table there's no need to use MLoad/FastLoad, as a simple SQL Insert/Select or Update wil be more efficient.