Error Operations in TeraData

Ratings:
(4)
Views: 651
Banner-Img
Share this blog:

 

Error operations

  .DML Lable{Lable Name}

{Mark/IGNORE}duplicate{Insert/update}Rows

{Mark/IGNORE}MISSING{Insert/update}Rows

Do Insert For{missions update}Rows

 

Error Operations    

 

Field

The value is loaded to the database.  

Filler

The value which skipped before loaded to the database

  Delimiter  

DML Label

A name to the DML Operation to differentiate from one to other  

 

Multi load Tables

For every table it Requires ET, UV, WT Table for every Import task, it Requires a log table  

Inclined to build a profession as Teradata Developer? Then here is the blog post on, explore Teradata Training

ET Table

  1. It takes the errors that occur in AQuision phase
  2. It contains primary index overflow error, that occurs in the application phase

Structure

The ET table contains the below fields

IMPORTSEQ

    • Sequence Number that identifies the import command where

DMLSEQ

    • Sequence Number for the DML statement invalid the error

SMTSEQ

    • The sequence of the DML statement being carried out when the error was discovered.

Applyseq:

    • Sequence Number that tells which Apply clause was Running when the error occurred

Sourceseq

    • The Record number in the input file which has an error

 

  Structure  

 

UV Table

it contains the error that occurs in the Application phase:

a)unique violation error

b) constrain error

c) overflow error on a column other than PI

 

  Structure  

  • Import Seq
  • Dml Seq
  • Smt Seq
  • Apply Seq
  • Source Seq
  • Unique
  • DBC error cod
  • DBC errorcod
  • DBC error Field  

Work Table

It contains DML Task Information

The input data that is Ready to Apply the amp1

Create multiset table w T c Parties

(

Field, Var Byte(64)Formal ’x(64)’NOT Null

) primary Index(Field);  

Log Table

2We need to specify this explicitly

2Mainly it is Import the time of Restorable the script    

For an in-depth knowledge, click on below

You liked the article?

Like: 0

Vote for difficulty

Current difficulty (Avg): Medium

EasyMediumHardDifficultExpert
IMPROVE ARTICLEReport Issue

About Author

Authorlogo
Name
TekSlate
Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.