TPT

Tools

TPT

Can any one suggest how to load duplicate records using TPT.

I have tried with TPT LOAD operator into MULTISET with NOPI table. But all the records are inserted into ERR1 table. Since load operator using FLOAD.

As UPDATE operator will use MLOAD operator, Please provide the sample code with UPDATE operator to load flatfile with ~ delimiter having duplicate records.

Kindly help me ASAP....

Thank You.

3 REPLIES
Teradata Employee

Re: TPT

Rows ending up in ERR1 are not due to duplicate rows.

They are due to bad data.

Running TPT LOAD against a NoPI table will load duplicate rows into that table.

-- SteveF

Re: TPT

But duplicate records are loaded neither ERR1 nor ERR2 table, discorded. Please suggest me how to load duplicate data flat file using TPT. We choosen TPT because it hae feature of ACCEPT MISSING Cols option.

Thank You.

Teradata Employee

Re: TPT

No. With the FastLoad protocol (TPT LOAD), duplicate rows are never placed in an error table.

They are either placed in the target/staging table (NoPI and MULTISET) or discarded altogether.

If you have rows in ERR1, it is because of bad data.

ERR1 is used primarily for data conversion errors.

If you look at the contents of ERR1, it will tell you which column and the DBS error number that caused the row to be placed in the error table.

ERR2 is used for uniqueness violation errors.

-- SteveF