![]() |
Hi ,
20 Feb 2016
| 2 comments
,
|
![]() |
Hi All,
03 Apr 2015
| 5 comments
,
|
![]() |
Need to load from Table 1 to Table 2. Which utility work well here and WHY?
27 Jan 2015
| 3 comments
,
|
![]() |
Hello,
06 Nov 2014
| 1 comment
,
|
![]() |
How does TPUMP Handle input file ?
27 Oct 2014
| 1 comment
,
|
![]() |
Hi guys,
04 Apr 2014
| 1 comment
,
|
![]() |
Hi All
17 Feb 2014
,
|
![]() |
The complete error message from Tpump log was:-
17 Sep 2013
| 2 comments
,
|
![]() |
Hi Experts,
10 Jul 2013
| 1 comment
,
|
![]() |
How to change session mode inside tpump script?
08 Mar 2013
| 1 comment
,
|
![]() |
Hi,
26 Nov 2012
| 1 comment
,
|
![]() |
Hello, How does TPUMP behaves if we have 2 rows with same UPI key in flat file? Is there any method it choose order of data while executing tpump? I have flat file with data as:
ID | Name 1 | A 1 | B
10 Aug 2012
| 1 comment
,
|
![]() |
Teradata Lead / Developer Experience from 3 to 10 years
28 Jun 2012
| 2 comments
,
|
![]() |
Hi, we have TD12.0 and use a generic load id that does tpump, multi load, fast load, fast export, ..... We have logging OFF for this id by default because logging on tpump is a big overhead. As a result we can't log for non-tpump jobs either.
01 Jun 2012
,
|
![]() |
Teradata has completed a major compiler conversion effort that should be completely transparent to customers, yet they are the main beneficiaries. This article:
The venerable IBM mainframe was the original client platform developed for the Teradata RDBMS via channel-attached connections way back in the 1980s. Although we now support a wide range of client platforms using network-attached connections, a significant segment of our customer base continues to use mainframe clients.
10 May 2012
| 3 comments
,
|
![]() |
Hi. I want to export data from one place and import it to other. Here is the source data declaration:
02 May 2012
| 2 comments
,
|
![]() |
TPump has been enhanced to dynamically determine the
22 Dec 2011
| 1 comment
,
|
![]() |
Teradata FastLoad has a feature named Tenacity that allows user to specify the number of hours that FastLoad continues trying to log on when the maximum number of load operations is already running on the Teradata Database. By default the Tenacity feature is not turned on. The feature is turned on by the script command:
14 Dec 2011
| 2 comments
,
|
![]() |
TPump macrocharset supportTPump now forces CHARSET internally when building its macros! This feature is new starting in TPump 13.10.00.03 release.
27 Dec 2010
,
|
![]() |
Hi, What do the following statements in the DML LABEL section in a tpump script do exactly: The input is a flat file with records inserting data into a database table.
16 Dec 2010
| 2 comments
,
|
![]() |
Hi all, I wanted to ask a question regarding Tpump loading into a Set table. Also, is there any difference between using tPump to load data into a Set and Multiset table?
30 Nov 2010
| 2 comments
,
|
![]() |
Hi, Can some one provide me the link to Teradata Load utilities for linux download location. I have searched the download center extensively with no result. I would like to install BTEQ,FASTLOAD,MULTILOAD,TPUMP utilites on linux box. Thanks
24 Jul 2010
| 4 comments
,
|
![]() |
This presentation describes, in detail, the various load utilities supported by Teradata.
15 Jul 2010
| 1 comment
,
|
![]() |
In TPump 13.00.00.02 and higher releases the maximum pack factor has been increased from 600 to 2430. TPump users use "PACK <statements>" in the "BEGIN LOAD" command to specify the number of data records to be packed into one request, where PACK is a TPump keyword and “statements” actually refers to the number of data records to be packed. Packing improves network/channel efficiency by reducing the number of sends and receives between the application and the Teradata Database.
12 Mar 2010
| 3 comments
,
|
![]() |
This book provides information on how to use Teradata Parallel Transporter (Teradata PT), an object-oriented client application that provides scalable, high-speed, parallel data extraction, loading, and updating. These capabilities can be extended with customizations or third-party products.
01 Feb 2010
| 1 comment
,
|
![]() |
This book provides information about Teradata Parallel Data Pump (TPump), a data loading utility that helps you maintain (update, delete, insert, and atomic upsert) the data in your Teradata Database. TPump uses standard Teradata SQL to achieve moderate to high data-loading rates.
01 Feb 2010
,
|
![]() |
This book provides information on how to use the Teradata Parallel Transporter (Teradata PT) Application Programming Interface. There are instructions on how to set up the interface, adding checkpoint and restart, error reporting, and code examples.
01 Feb 2010
,
|
![]() |
This book provides reference information about the components of Teradata Parallel Transporter (Teradata PT), an object-oriented client application that provides scalable, high-speed, parallel data extraction, loading, and updating. These capabilities can be extended with customizations or with third-party products.
31 Jan 2010
| 1 comment
,
|
![]() |
This book provides reference information about the components of Teradata Parallel Transporter (Teradata PT), an object-oriented client application that provides scalable, high-speed, parallel data extraction, loading, and updating. These capabilities can be extended with customizations or with third-party products.
19 Jan 2010
| 2 comments
,
|
![]() |
Suppose you have a table with several non-unique secondary indexes (NUSI). When TPump loads the table, should you expect that each row’s INSERT will cause a table level lock on each of the secondary index sub-tables? And if so, couldn’t this create a lot of blocking across sessions?
14 Dec 2009
| 2 comments
,
|
![]() |
A high-availability system must have the ability to identify and correct errors, exceptions and failures in a timely and reliable manner to meet challenging service level objectives. The Teradata database and the utilities and components (used to both load and access data) provide capabilities to implement reliable error and exception handling functionality. These capabilities combined with a well designed high availability architecture allow a Teradata Active Enterprise Intelligence (AEI) system to meet the service level objectives required to support mission critical business processes.
15 Sep 2009
,
|