Teradata Parallel Transporter is the preferred load/unload tool for the Teradata Database. Parallel Transporter is able to run all the bulk and continuous Teradata load/unload protocols in one product. In the past, a user had to run the protocols with separate tools with different script languages. The stand-alone load tools, FastLoad, MultiLoad, TPump, and FastExport are functionally stabilized and no new features are being added other than to keep them operational in supporting new Teradata Database releases.
All new features requested by customers are being added to Parallel Transporter. Currently, the stand-alone load tools are being supported indefinitely and no discontinuation notice has yet been issued. It is recommended that all new Teradata load applications be implemented with Parallel Transporter.
- Application Program Interface (API) – used by leading ETL vendors for tight, parallel, high-performance integration
- Script – used when a customer doesn’t have an ETL tool
- Command line (sometimes referred to as the Easy Loader interface) – used to load data from a flat file with a single command line
- Wizard – used to generate simple scripts. Use this tool as a way to learn the script language and not as a production load interface.
- Load Operator – bulk loading of empty tables (FastLoad protocol)
- Update Operator - bulk load/update/upsert/delete of tables (MultiLoad protocol)
- Stream Operator continuous loading of tables (TPump protocol)
- Export Operator bulk unloading of tables (FastExport protocol)
If you run TPT with the script interface, a TPT infrastructure component interprets the script and invokes the proper Operators to read and load the data.
If you use and ETL tool, the ETL tool will read and transform the data and pass the data in memory to the TPT API interface which will invoke the proper Operator to load the data.
No comments:
Post a Comment