Below are the loader utilities for the Teradata.
- FastExport : Extracts data from Teradata
- FastLoad : Loads large volume data into an empty Teradata database table.
- Multiload : High load batches and performs update, insert, upsert, and delete operations against Teradata database tables.
- Tpump : Moderate to high loads and performs update, insert, upsert, and delete operations against Teradata database tables in near real time mode.
Things to evaluate while choosing Teradata PT mode
- Limited Database Resource
- Data Volume
- Concurrent Processing
- Real-Time
- Constraint Based Loading
- Data Accessibility
- Restart complexity
- Debugging complexity
No comments:
Post a Comment