Oct 16
Fastload Commands Given below is the list of Fastload commands which is extensively used in creation of Fastload scripts. ERRLIMIT Specifies the maximum number of rejected ROWS allowed in error table 1 (Phase I). LOGON/LOGOFF or, QUIT LOGON begins a session. LOGOFF ends a session. QUIT is the same as LOGOFF. NOTIFY NOTIFY command used …
Oct 13
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 *****/ …
Oct 06
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 …
Oct 06
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 …
Feb 23
There are few limitations which we have on Fastload. These limitations are necessary for Fastload to load data with the lightning fast speed into tables. NO SECONDARY INDEXES ARE ALLOWED ON TARGET TABLE – Fastload can load tables only with primary indexes defined on it. If we have a secondary index on the table then …
Feb 21
Fastload is use to load vast amounts of data from flat files to empty tables of Teradata, with a lighting fast speed. Fast load is specially designed to load millions of rows in Teradata tables in a very less time as compared to other conventional methods. Fastload can run from either mainframe or network host. …
