Teradata DBA Classroom Training and Certification Classes

1. User Management
2. Space Allocation
3. Access of Database Objects
4. Security Control
5. System Maintenance
6. System Performance
7. Resource Monitoring
8. Data Archives, Restores and Recovery

When the number of rows to be retrieved into the spool is limited by applying a filter, it is known as residual condition.

Merge, Nested, Hash, Product and Exclusion

Number of AMPs, size of row in a table, frequent access of table, number of records in table and frequency of data being refreshed are some of the considerations for a skew factor.

• Perm space
• Spool space
• Temp space

• Transient journal
• Permanent journal
• Down AMP recovery journal

Fallback protects the data from both hardware and software failure as well as automatically recovers it with lowest possible recovery time.