Dec 12
Practice 2 You may also want to check below mentioned Practice Papers for completer reference – Practice 1 Practice 1 I have also identified few E books which is immensely useful for Teradata Certification Preparation. Please have a look and if you are seriously preparing for TD certifications then don’t hesitate to purchase it.(Hover the …
Nov 20
Each table in Teradata is required to have a primary index.Even if you did not define any primary index in CREATE table statement, the Teradata system will automatically create the primary index based on the setting of DBScontrol setting field . The primary index defines where data will reside and which AMP receives the row. …
Aug 03
COLLECT STATS is one on the most useful utility in Teradata. It helps Parsing Engine (PE) to make an effective plan to execute query, so that less resource are utilized and performance is improvised. But there is a serious confusion between doing COLLECT STATS on column level or table level. Here i like to explain …
Jul 26
Teradata 12 Certified Associate. Business user certification (Teradata 12 Certified Associate ) is the newest addition to the Teradata Certified Professional Program (TCPP). The certification exam was developed specifically for Teradata Business Professionals who use Teradata’s technology in less technical job roles.The target audience is the Business Professionals of various fields like Marketing, Sales, Finance, …
Jun 21
This is the query to find the amount of space which each table occupy in there respective Database. SELECT DATABASENAME (TITLE ‘Database’) ,TABLENAME (TITLE ‘Table Name’) ,SUM(CURRENTPERM)/(1024*1024*1024) (DECIMAL(15,6)) (TITLE ‘Current Perm Space(GB)’) FROM DBC.TABLESIZE WHERE DATABASENAME = ‘YOUR_DATABASE_NAME‘ GROUP BY 1,2 ORDER BY 3 DESC Where ‘YOUR_DATABASE_NAME‘ is the name of the database for which …
Jun 21
Space allocation is the most primary and important part in any Database. Teradata gives us the unique set of System Tables, with the help of which, we can do some useful space allocation calculation. Sometimes when there is no more space left in the System then we need to check in the existing databases and …
Apr 18
The Teradata database uses Recovery Journal to automatically maintain data integrity in the case of : An interrupted transaction An AMP failure Recovery Journals are created, maintained and purged by the system automatically, so no DBA intervention is required. Recovery journal are tables stored in the storage medium so they take up the disk space …
