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 …
Mar 14
Question 1: Difference between MultiLoad and TPump? Answer: Tpump provides an alternative to MultiLoad for low volume batch maintenance of large databases under control of a Teradata system. Tpump updates information in real time, acquiring every bit of a data from the client system with low processor utilization. It does this through a continuous feed …
Mar 09
Question 1: What is the fallback or no fallback option while creating table DDL? Answer: FALLBACK requests that a second copy of the each rows inserted into the table has a duplicate copy in another AMP in the same cluster. This way we can make the copy of the data inserted into tables. While NO …
Mar 05
Teradata is designed in such a fashion, to reduce the DBA’s administrative functions when it comes to space management. Space is configured in the following ways in Teradata system – 1) PERMANENT SPACE 2) SPOOL SPACE 3) TEMPORARY SPACE 1) PERMANENT SPACE – Permanent space is where the objects (i.e. – databases, users, tables) are …
