Author's posts
Oct 16
Teradata Utilities – FASTLOAD part 4
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
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 *****/ …
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 …
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 …
May 16
Secondary Index in Teradata
Before you start with SI, well I must say that as a prerequisite you must first read about the Primary index in Teradata. So after knowing about Primary index the point here is that when we already have UPI and NUPI then what’s the use of this Secondary Index? Well the best possible answer for …
May 11
What is a pseudo table Lock in Explain Plan?
When you want to retrieve the rows from the table, the very first step in explain plan is the pseudo table lock on that table e.g – Type select * from <databasename>.<tablename> in the SQL assistant, and do the explain plan for this table. The very first step you see is – 1) First, we lock …
Apr 21
SET or MULTISET tables
We know that in Teradata all the tables are either SET or MULTISET. The difference between SET and MULTISET tables is – SET tables – SET tables did not allow duplicate values in the table. e.g. COLUMN 1 COLUMN 2 COLUMN 3 COLUMN 4 A b c d H g y k A …
Sponsors of Teradata Tech
