Teradata Utilities - BTEQ, FastLoad, FastExport, TPT

Tutorials about Teradata utilities incl. BTEQ, FastLoad, FastExport, TPT, etc.

Examples are provided about loading XML, JSON and CSV files into Teradata and also about exporting data from Teradata database. 

Teradata Utilities - BTEQ, FastLoad, FastExport, TPT

local_offer teradata local_offer teradata-utilities

visibility 239
thumb_up 0
access_time 3 months ago

TPT (Teradata Parallel Transporter) is a client suit that support multiple instances of data extracting, loading, and updating functions in a scalable, high-speed, parallel-processing environment. It utilize other client tools like FastLoad, FastExport, MultiLoad, etc.  It is written with Java ...

local_offer teradata local_offer fastload local_offer teradata-utilities

visibility 282
thumb_up 0
access_time 3 months ago

Teradata FastLoad is a command line utility that can be used to load large amount of data into an empty table on Teradata database. The performance will be greater than line by line or batch processing mechanism. This article provides example of using FastLoad to load CSV file into Teradata ...

local_offer teradata local_offer fastload local_offer teradata-utilities

visibility 80
thumb_up 0
access_time 3 months ago

Teradata FastLoad can be used to load CSV/TSV or other delimited files into database. Refer to article  Teradata FastLoad - Load CSV File  for more details about how to load CSV into Teradata. This article shows how to skip header line or multiple lines in the input file.  Create a ...

local_offer teradata local_offer fastload local_offer teradata-utilities

visibility 156
thumb_up 0
access_time 3 months ago

In article  Teradata FastLoad - Load CSV File , it shows how to load CSV into Teradata. The input file is very basic CSV file.  This article expands on that to provide examples about loading CSV files with optional quoted fields to skip delimiters. It also shows how to load files with ...

local_offer teradata local_offer teradata-utilities

visibility 139
thumb_up 0
access_time 3 months ago

Teradata FastExport is a command utility tool that can transfer large amount of data from Teradata database to a file.  One of the commonly used scenarios is to export data from a table or view to a text file and then load the export file into a different server.  Follow the following ...

local_offer teradata local_offer teradata-utilities

visibility 256
thumb_up 0
access_time 3 months ago

Teradata Parallel Transporter (TPT) provides rich functions to load data into Teradata and to export data. In article Load CSV into Teradata via TPT , it shows how to load CSV files into Teradata. This page provides examples to export data from Teradata to CSV. Use TPT wizard GUI tool to create a ...

local_offer teradata local_offer teradata-utilities

visibility 50
thumb_up 0
access_time 3 months ago

BTEQ is a Teradata utility tool that can be used to run Teradata SQL statements incl. DDL, DML, etc. It can also be used to import data from text file into Teradata databases. Like TPT and FASTLOAD, it can run in both batch and interactive modes. This article demonstrates how to load XML file into ...

local_offer teradata local_offer teradata-utilities

visibility 104
thumb_up 0
access_time 3 months ago

BTEQ is a Teradata utility tool that can be used to run Teradata SQL statements incl. DDL, DML, etc. It can also be used to import data from text file into Teradata databases. It also works with XML and JSON files too. Like TPT and FASTLOAD, it can run in both batch and interactive modes. This ...

Read more

Find more tags on tag cloud.

launch Tag cloud