Teradata Popular Utilities |
Top Utilities
1# MultiLoad
Inserts, updates, deletes, or upserts rows in a Teradata table by using the MLOAD command-line utility. It can handle Multiple Sql Statements in a single operation.You can provide user-defined SQL for complex operations. This stage is best used for bulk updates, deletes, upserts, and complex interface operations.
2# TPump
Inserts, updates, deletes, or upserts rows in a Teradata table using the TPUMP command-line utility. It can do concurrent updates on the same table. It can Handle Multiple Sql statements in a single operation. You can provide user-defined SQL for complex operations.3# FastExport
Exports data from a Teradata table by using the FEXP command-line utility. You can customize it to use user-defined SQL statements for extraction. This stage is best used for bulk extracts from Teradata.Also Read: Teradata datawarehousing and analytics
This post first appeared on SriniTera - Data Analysis Solutions, please read the originial post: here