Trianz Technical Lead Interview Questions, Process, and Tips for Experienced

Teradata architecture and performance tuning techniques

• Teradata architecture consists of parsing engine, BYNET, access module processors, and storage

• Performance tuning techniques include indexing, partitioning, and query optimization

• Indexing involves creating indexes on frequently accessed columns

• Partitioning involves dividing large tables into smaller ones for faster access

• Query optimization involves rewriting queries

Primary and secondary indexes in Teradata and their importance

• Primary index is used for data distribution and is defined at table creation

• Secondary index is used for faster access to data and can be added after table creation

• Indexes improve query performance by reducing data retrieval time

• Indexes can also improve data loading time by reducing the need for full table scans

• Choosing the right index type and columns is imp

Teradata has various types of tables including SET, MULTISET, VOLATILE, GLOBAL TEMPORARY, QUEUE, and NO PRIMARY INDEX tables.

• SET tables enforce uniqueness of primary index values.

• MULTISET tables allow duplicate primary index values.

• VOLATILE tables are temporary and are automatically deleted at the end of a session.

• GLOBAL TEMPORARY tables are temporary and can be accessed by multiple sessions.

• QUEUE tables are used for m...read more