Teradata Developer Training Online

Teradata is an open system and is capable of running on both single-nodes and multi-nodes. It is compatible with the ANSI standards and acts in fashion similar to a server.

Automated temporal analytics, extension of compression capabilities and viewpoint are some of the newly developed features of Teradata.

• Virtual Disk (vDisk)
• Access Module Processor (AMP)
• Bynet
• Parsing Engine (PE)
• Virtual Storage System (VSS)

By using Identity Column

DataStage, Informatica, SSIS etc.

• Access Lock
• Read Lock
• Write Lock
• Exclusive Lock

Amp helps to perform DML and DDL, implement aggregations and joins, and release and apply locks, etc.

A Parser checks three things - semantics error, syntactical errors and object existence

By using any of the four ways - Teradata Visual, Request Modifier, Teradata Manager and Performance Monitor.

• Preliminary Phase
• DML Phase
• Data Acquisition Phase
• Application Phase
• End Phase.