TERADATA

  There can be different scenario’s where Teradata database needs to be stopped and started by database administrator or the database restarted automatically. So there …

  There are thousands of queries submitted per minute and it is too much data. But, To avoid the performance impact on the database due …

  Following query will verify if any DBQL rule exists: locking table DBC.DBQLRuleTbl for access [crayon-6474014a464f0165521855/]   Note: View DBC.DBQLRules OR DBC.DBQLRulesV can also be …

  On day to day activity we often get situation when the database has a lot of space left but query fails with “2644: No …

  To configure Viewpoint follow below steps: [crayon-6474014a46ac2568727583/]   After running the above steps then do the below service restart: [crayon-6474014a46ac6751803299/]   Teradata Alerts contains …

  Setting up a connection for Excel to the Teradata database was a little bit of a challenge. In this example, the Operating System was Windows …

  Teradata 15.0 has come up with many new exciting features and enhanced capabilities  . Teradata Query Grid is one of them. Teradata database now able …

  Every table must have at least one column as the Primary Index. The Primary Index is defined when the table is created.There are two reasons you …

Secure Zones This feature supports grouping of users, databases, and database objects into Secure Zones. Business Value This feature provides the following business value: Improves …

  Teradata architecture is based on Massively Parallel Processing (MPP) architecture. The major components of Teradata are Parsing Engine, BYNET and Access Module Processors (AMPs). …