Teradata architecture
- PE Component
- BYNET Component
- AMP Component
- Important dictionary views/tables need to manage Database.
Managing Space
- Spool
- Permanent
- Temporary
- Skew factor
- Space management
- Hashing algorithm
- Data retrieval
- Storage in Teradata
Managing users and Database
- Roles
- Profiles
- Hierarchy of user/DB (basic of designing part)
- Access rights (Explicit/Implicit AUTO)
- Session related Views/Tables
- Locking types
- Query logging
- Logon off tracking
Performance tuning
- Join strategy in Teradata
- Joins terms in Explain plan
- Index types (PPI SI and JI)
- Query tuning
- DBQL logging
- Reuse tables
- DBQL
- PDCR data
- Workload management (TASM) Resource partitions
- Priority scheduler
- Workload classifications
- Exceptions
BAR
- ARCMAIN
- Backup
- Copy/Restore
- Build
- Net vault/Netback up
Teradata tools
- Console utilities QRYCONFIG
- QRYSESSN
- RCVMANAGER
- SHOWLOCKS
- VPROCMANAGER
- SHOWSPACE
- SHOWBLOCKS
- PACKDISK
- SCANDISK
- Viewpoint (TD 13)
- Teradata Manager
- PMON
- SQL assistant
- TD Administrator
Teradata loading utilities
- Fast load
- Multi load
- Fast Export
- TPUMP
|