Mar 22

Query to find user access and roles in Teradata

Teradata developers have to face the scenarios where they need to check whether their user id (or someone else in their team) has access to particular database or table in Teradata. For this trivial question, it’s not wise to disturb the admin/DBA team if you can check it yourself by querying on just 2 DBC tables. …

Continue reading »

Mar 06

Active Database for Interview Questions

  Dear Readers, We at TeradataTech, like the idea of creating a database where we can capture all the questions asked by different technical recruiters. So that our readers can prepare well before appearing for any Teradata related interviews. This database of interview questions will come only from you all, and we encourage everyone who has …

Continue reading »

Jan 11

Teradata Tech Associates

Greetings from www.teradatatech.com !!! We at TeradataTech are looking for professionals who are interested in technical work related with Teradata, data warehouse and other relevant technologies. Approximate of 3-4 hours on weekends or 1-2 hours on weekday effort is required based on your preference. Currently we have multiple requirements like – Technical blog writers in …

Continue reading »

Nov 04

Recursive Query in Teradata

Guest Post  Author – Saurabh Gupta In this post we will go through recursive query with one example. The recursive query features enables to query hierarchical data such as an organisation chart or bill of materials ( check the raw materials used to make a product ). Using Recursive query data with in the single table can be …

Continue reading »

Oct 10

ROLLUP Function with Example

Guest Post  Author – Saurabh Gupta   In this post we will go through ROLLUP function which is one of the Extended grouping function. ROLLUP is used to aggregate data along all the levels of hierarchy within a single dimension. For example –  In time dimension data can be aggregated along different levels like day, week, month and …

Continue reading »

May 21

Teradata No Primary Index Tables

What are No Primary Index tables ? Starting with Teradata Release 13, tables can be defined without having a primary index. As we all know, the primary index is the main idea behind an evenly data distribution on a Teradata system. By design, the primary index ensures that a Teradata system is unconditionally scalable. Hence, …

Continue reading »

Jan 17

Teradata 14 Certification

Teradata 14 is the latest certification track launched by teradata after Teradata 12 certification. Teradata 14 certification covers the following database – Teradata 13.0 Teradata 13.10 Teradata 14.0 The list of exams is as follows –   Exam Exam Title Testing Time TE0-141 Teradata 14 Basics exam 1 hour 30 minutes TE0-142 Teradata 14 SQL exam …

Continue reading »

Older posts «