context date February 2011 FastExport is a computer program released by the company Teradata . The program is the reverse of the Teradata FastLoad . FastExport is a utility that exports large data sets from Teradata tables or views to a client system for processing, generating large reports, or for loading data into a smaller database. FastExport can export data to both channel or network attached client systems. The program also provides session control and data handling specifications for the data transfer operations. The program is available for various operating system s, including Microsoft Windows and Red Hat Linux . Usage FastExport is a command driven utility that uses multiple sessions to quickly transfer large amounts of data from tables and views of the Teradata Relational Database Management System RDBMS to a client based application. Users can export data from any table or view to which you have the SELECT access privilege. The destination for the exported data can be A file on a channel attached or network attached client system An Output Modification OUTMOD routine written to select, validate, and preprocess the exported data A Sample Script pre .LOGTABLE utillog define restart log .LOGON tdpz user,pswd DBC logon string .BEGIN EXPORT specify export function SESSIONS 20 number of sessions to be used .LAYOUT UsingData define the input data .FIELD ProjId Char 8 values for the SELECT .FIELD WkEnd Date constraint clause. .IMPORT INFILE ddname1 identify the file that LAYOUT UsingData contains the input data .EXPORT OUTFILE ddname2 identify the destination file for exported data SELECT EmpNo, Hours FROM CHARGES provide the SQL SELECT WHERE WkEnd WkEnd statement with values AND Proj ID ProjId provided by the IMPORT ORDER BY EmpNo command .END EXPORT terminate the export operation .LOGOFF disconnect from the DBS pre Empty section date July 2010 External links Dead link url http www.teradata.com t page 94244 index.html titre Teradata Load & Unload Utilities date ... more details
Advert date December 2007 Teradata Parallel Transporter TPT is a Teradata load utility, typically used in data warehousing . Teradata Parallel Transporter Teradata Parallel Transporter TPT is a Parallel computing parallel multi function load environment. It provides scalable access to data sources from a single interface using a single SQL like scripting language or an open API. It provides a completely parallel environment. Dozens of files can be loaded using a single script. TPT utilizes system resources efficiently by allowing distribution of the workload across CPUs, eliminating bottlenecks in data loading process. Each user can create a job that is, a string of TPT commands that allows them to perform operations, such as heterogeneous data access, data integrity checks, data merging, and data loads in batch or near real time. Teradata Parallel Transporter provides a set of open APIs that enables integration of third party tools or custom applications. It was designed to use the different Teradata Load and Unload Utilities under a single infrastructure. So, based on the protocols of fastload, multiload, tpump and fastexport, new operators were developed and they are named as Load, Update, Stream and Export respectively. Apart from the four operators, there are more operators like Selecto, Inserter, Dataconnector, and ODBC . Teradata Parallel Transporter is available with Informatica as well. Features Single infrastructure for all loading needs using single scripting language Integrated API to interface with ETL tools and custom programs Completely parallel Combines functionality of Teradata Teradata FastLoad FastLoad , MultiLoad , FastExport , and TPump Supported Platforms NCR UNIX SVR4 MP RAS IBM z OS MVS Microsoft Windows 2000, XP, Vista and Server 2003 Sun Solaris SPARC HP UX IBM AIX Red Hat Linux SUSE Linux Enterprise Server from Novell External links http tptapiwrapper.codeplex.com .Net Wrapper for the Teradata Parallel Transporter API Category Data warehou ... more details
Encyclopedia
top
