what is the sqlloader equivalent in Teradata

UDA

what is the sqlloader equivalent in Teradata

I just have one question.... do we have anything in Teradata that is equivalent to sqlloader in oracle?
How can we extract data from files to a table in Teradata(excluding fastload and multiload).
4 REPLIES

Re: what is the sqlloader equivalent in Teradata

Teradata SQL assistant also allows you to load data from files to tables. but is a bad idea for a large amount of data. generally good for small samples / reference tables kind of scenarios.

And then there's the bteq (again good for small data) and the TPT operators that mimick the performance and functionality of the heavy duty load utilities.

Re: what is the sqlloader equivalent in Teradata



Check out BTEQ import...

Re: what is the sqlloader equivalent in Teradata

one more option is Tpump
TPump
=====
* Loads data to TeraData from aMainframe or Lan flat file
* Processes INSERTS, UPDATES or DELETES
* Tables are usually populated.
* Can have Secondary Indexes and RI on tables.
* Does not support MULTI-SET tables.
* Locks at the row hash level
* It uses time based checkpoints not count based.

Re: what is the sqlloader equivalent in Teradata

Hi Alex,
Can you please let me know more on BTEQ import?