Hi , 
Can anyone explain me whether TPT Stream Operator(TPUMP) can be used to load data from file to table and table to file. If it is possible could you kindly provide the script for the same. 
In my view, TPT Stream Operator is best suitable for mini batch loads. Could you confirm this also please. 
 
Thank you,

Hi All,
I am new to Teradata. I am facing an issue while trying to load to the same TD target table from multiple staging tables simultaneously. I searched the net but got confusing inputs. Please help me clarify what my options are regarding the following. We are using TD 15.

Need to load from Table 1 to Table 2. Which utility work well here and WHY?
Please explain the limitations and advantages against each utility.

Hello,
In my mload script i have the following:
0037 .IMPORT INFILE xxxx
        FROM 4
        FORMAT  VARTEXT '^\' NOSTOP
        LAYOUT &load_table.
        APPLY Inserts;
The multiload skips the errors and inserts the records which respects the conditions
 

How does TPUMP Handle input file ?
 
if the source system keep on appending data to same file ..
and tpump keep on loading to teradata , at some point file becomes huge and need to be deleted 
then do we need to handle the process manually ?
 
Thanks.
 

Hi guys,
just want to ask the purpose of Serialize ON in TPUMP. How is it related to the types of blocking or locking if it is not specified in a TPUMP? Are there any circumstances that would affect the blocking or locking?
 
Thanks! :)
 

Hi All
We have a requirement where we need to load one single table in parallel from different source tables.
Say, TableX needs to be loaded from TableA, TableB and TableC. They have different source data (Rows).

The complete error message from Tpump log was:-
 UTY8001 RDBMS failure in Macro Build: 2673, The source parcel length does not match data that was defined.
My data source is (first several records)
731727336!1!2100034078!1!2.4!1.3!1!2005-07-01 09:12:13.000000!1!2005-07-01 09:12:24.000000!2005-07-01!20!11:46:54.170000

Hi Experts,
There is a tpump which is taking 10 hours to process 7000 records, whcih earlier was taking 1 hour..  not sure why its taking 
so long now. the script cotains the normal insert select statement. 
just want to know that is there any optimal parametrs setting for the various TPUMP parameters..
like 
PACK

How to change session mode inside tpump script?

Hi,
I am calling tpump script through a shell script  which loads the data from a flat file to an Teradata table.
While trying to load the data from the flatfile to the table, the script exists with the below error.
Kindly help me understand why and when this error occurs and also help with getting over such issues. Thank you.

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

Teradata Lead / Developer

Experience from  3 to 10 years

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.

Hi. I want to export data from one place and import it to other. 

Here is the source data declaration:

Hi,

What do the following statements in the DML LABEL section in a tpump script do exactly:
IGNORE MISSING ROWS
IGNORE EXTRA ROWS;

The input is a flat file with records inserting data into a database table.

Hi all,

I wanted to ask a question regarding Tpump loading into a Set table.
If the load fails, can it pick up again and continue from where it failed? Or does there have to be some form of clean up and restarting of the job?

Also, is there any difference between using tPump to load data into a Set and Multiset table?

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