How To Start and Stop Teradata Database
There can be different scenario's where Teradata database needs to be stopped and started by database administrator or the…
0 Comments
October 27, 2018
Why is so much data being written into DBQL?
There are thousands of queries submitted per minute and it is too much data. But, To avoid the performance…
October 17, 2018
DBQL rules – QUERY LOGGING
Following query will verify if any DBQL rule exists: locking table DBC.DBQLRuleTbl for access [crayon-5f06f0f58a96c796430405/] Note: View DBC.DBQLRules…
September 10, 2018
Hash Functions to Identify Skewed Data
On day to day activity we often get situation when the database has a lot of space left but…
September 5, 2018
How To Configure Viewpoint Service In Teradata
To configure Viewpoint follow below steps: [crayon-5f06f0f58b008373719908/] After running the above steps then do the below service restart:…
September 5, 2018
Creating an ODBC Connection to Teradata for Excel
Setting up a connection for Excel to the Teradata database was a little bit of a challenge. In this example,…
August 28, 2018
Teradata Query Grid : Connection with different systems ( Database , NoSQL , Hadoop )
Teradata 15.0 has come up with many new exciting features and enhanced capabilities . Teradata Query Grid is one of…
August 27, 2018
Primary index concept in Teradata
Every table must have at least one column as the Primary Index. The Primary Index is defined when the table is…
August 14, 2018
Teradata – Secure Zones
Secure Zones This feature supports grouping of users, databases, and database objects into Secure Zones. Business Value This feature provides…
August 13, 2018
Teradata – Architecture
Teradata architecture is based on Massively Parallel Processing (MPP) architecture. The major components of Teradata are Parsing Engine, BYNET…
August 9, 2018