Increasing no of amps will increase performance. Is this
true?
Post New Answer View All Answers
What are the main components of teradata system?
Highlight the advantages of PPI(Partition Primary Index).
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What are the functions performed by bynet?
What is node? How many nodes and amps used in your previous project?
In BTEQ, how are the session-mode parameters being set?
What is a sparse index?
Explain teradata architecture?
In the Primary Index, what is the score of AMPs that are actively involved?
What are the steps involved after the disk manager passes the request?
Explain the teradata primary index mechanics in detail with a diagram.
How do you create tables? Exact syntax, and create profiles, users in teradata?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Can we collect statistics on multiple columns?
What's the difference between timestamp (0) and timestamp (6)?