TPT Performs operations that are extract, load, transform, etc to the below 4 operations
Reads data source and writes to data streams the below operators are available in producer operator
| Operator | Description |
| EXPORT | Fast export utility to export data to file form tables. |
| SQL Selector | Select data form tera data tables with SQL Sessions |
| Data connector | Reads data from external files. |
| ODBC Operator | Extract data from any ODBC Provider on windows, unix, MVS platforms. |
Fast load in mod adaptor
Multi load in mod adaptor
Reads data from data streams and writes to a tera database the below sub operators are available
| Operator | Description |
| Load Operator | Implement Fast Load functionality, loading to empty tables |
| Update Operator | Implement multi-load functionality loading to 5 tables |
| Stream Operator | Implement TPUMP Protocol continuous loading data to tera data tables |
| SQL Inserter | Inserter data into tera data tables, with SQL session |
| Data connector | Writes data to an external file to access module |
Inclined to build a profession as Teradata DBA Developer? Then here is the blog post on, explore Teradata DBA Training
| PT Operator | Max Tables |
| Load | 1 |
| Update | 5 |
| Stream | 127 |
| SQL Inserter | 1 |
Fast export out mod adaptor
Read and write data from and to stream and perform data transformation function such as selection, validation, conjoins
Standalone processing that does not in value sending(or)Receiving to and from the data stream it does not operate on the data stream.
The below stand lone operators are available
| Operator | Description |
| DDL Operator | Create indexes, tables, drop tables, delete table, replace, rename, macro, views, name, etc operations |
| Update operator | Use when performing delete the task and there is no data need for the delete SQL Request |
| OS Command | It executes os command on the client system |
Takes operator, operator attributes
Define data structure the data an operator will process
Unique structure for every object
Runs tera data PT Job parallel transporter
View the content of log file produced for running a tera data-parallel transporter job
Type<operator>
Schema<name>(or)*
Example
Type load
Schema se- party
Attribute
(
----
----
)
Sessions Take multiple connections to the script while processing
Generally fast load, multi-load, TPUMP, and fast export use session.
Instance is used by the operators to process the data gallery
Ex: min sessions=2;
Max sessions=8;
Syntax operator:[NUMBER]
EX: Load- party[4]
You liked the article?
Like: 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
