Category Archive: TD Utilities

Oct 13

Teradata Utilities – FASTLOAD part 3

A sample Fastload script Below is the sample Fastload script which is designed to work in WINDOWS OS. To run the Fastload in your system you need to install Fastload utility and then go to command prompt and type – >fastload < c:\fload_1.txt where c:\fload_1.txt is the name and path of the Fastload which you want to execute. A sample Fastload script /***** Section 1 *****/ …

Continue reading »

Oct 06

Teradata Utilities – FASTLOAD part 2

Phases of Fastload Fastload divides its job into two phases 1)       Phase 1 – Acquisition 2)      Phase 2 – Application Phase 1 – Acquisition The main objective of this phase is to send rows of data file from HOST computer to Teradata AMPs as fast as possible. Rows of the data file are packed into …

Continue reading »

Oct 06

Teradata Utilities – FASTLOAD part 1

Introduction Fastload is the Teradata utility which can be used to load large amount of data in empty table on a Teradata System.  The property which makes Fastload UNIQUE is its fast speed to load huge amount of data in tables. You can load data from – Disk or Tape drives from the channel attached …

Continue reading »