Answer Posted / tdguy
Access Module Processor stores and retrieves the
distributed data in parallel. Ideally, the data rows of
each table are distributed evenly across all the AMPs.
Their job is to receive the optimized plan steps, built by
the PE after it completes the optimization, and execute
them.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain teradata utilities. What is multiload, fast load, tpump?
Explain amp in teradata?
What are the various etl tools in the market?
Highlight the differences between Primary Key and Primary Index.
What is a sparse index?
What are the things to be considered while creating secondary index?
What is the difference between union and union all in teradata?
What are differences between teradata and ansi session modes in teradata?
Highlight the points of differences between the database and user in Teradata.
What are the uses of client software involved in teradata?
What is the multi-insert?
What is the purpose of upsert command?
What are the various indexes in teradata?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
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?