One of the primary reasons why TERADATA is considered such a valuable product in market because of the utilities that are provided by teradata database.
They are five teradata utilities available They are a)BTEQ b)FAST EXPORT c)MLOAD d)FLOAD e)TPUMP
Let me give an overview about these utilities
a)BTEQ - It stands for basic teradata query. In BTEQ we can perform various DDL and DML operations i.e. create,insert,merger,update,delete.
It can be run in two modea i.e. interactive and batch mode.
In here we can use BT & ET functions these represent begin transaction and end transaction respectively.
We can write multiple sql statement with in these two and commit action will be performed upon successful execution of all statements
If any of the sql statements fails then the data will be roll-backed.
b)FAST EXPORT - FastExport ,the name itself is spells to exports data from Teradata to a Flat file.
But BTEQ also does the same thing.The main difference is BTEQ exports data in rows and FastExport exports data in 64K block so it does super fast
FastExport only supports the SELECT statement.
c)MLOAD - MLOAD means multiload
Load, update and delete large tables in Teradata in a bulk mode
Multiple tables can be loaded at a time.
Updates data in a database in a block mode
Duplicate rows allowed
d)FLOAD - FLOAD means fast load
The target tables must be empty in order to use Fast Load
Supports inserts only - it is not possible to perform updates or deletes in Fast Load
Although Fastload uses multiple sessions to load the data, only one target table can be processed at a time
Teradata Fast load does not support join indexes, foreign key references in target tables and tables with secondary index defined.
It is necessary to drop any of the constraints listed before loading and recreate them afterwards.
Duplicate rows are not allowed
e)TPUMP - It stands for teradata parallel data pump
Main use: to load or update a small amount of target table rows
Sends data to a database as a statement which is much slower than using bulk mode
TPump uses row-level hash locks
TPump does not support MULTI-SET tables.
Hope this article helps you in understanding basic functionalities of teradata utilities
They are five teradata utilities available They are a)BTEQ b)FAST EXPORT c)MLOAD d)FLOAD e)TPUMP
Let me give an overview about these utilities
a)BTEQ - It stands for basic teradata query. In BTEQ we can perform various DDL and DML operations i.e. create,insert,merger,update,delete.
It can be run in two modea i.e. interactive and batch mode.
In here we can use BT & ET functions these represent begin transaction and end transaction respectively.
We can write multiple sql statement with in these two and commit action will be performed upon successful execution of all statements
If any of the sql statements fails then the data will be roll-backed.
b)FAST EXPORT - FastExport ,the name itself is spells to exports data from Teradata to a Flat file.
But BTEQ also does the same thing.The main difference is BTEQ exports data in rows and FastExport exports data in 64K block so it does super fast
FastExport only supports the SELECT statement.
c)MLOAD - MLOAD means multiload
Load, update and delete large tables in Teradata in a bulk mode
Multiple tables can be loaded at a time.
Updates data in a database in a block mode
Duplicate rows allowed
d)FLOAD - FLOAD means fast load
The target tables must be empty in order to use Fast Load
Supports inserts only - it is not possible to perform updates or deletes in Fast Load
Although Fastload uses multiple sessions to load the data, only one target table can be processed at a time
Teradata Fast load does not support join indexes, foreign key references in target tables and tables with secondary index defined.
It is necessary to drop any of the constraints listed before loading and recreate them afterwards.
Duplicate rows are not allowed
e)TPUMP - It stands for teradata parallel data pump
Main use: to load or update a small amount of target table rows
Sends data to a database as a statement which is much slower than using bulk mode
TPump uses row-level hash locks
TPump does not support MULTI-SET tables.
Hope this article helps you in understanding basic functionalities of teradata utilities
Comments
Post a Comment