Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

how to load or extract the error table data ?

Question Posted / kk

Answers were Sorted based on User's Feedback



how to load or extract the error table data ?..

Answer / yuvaevergreen

Loading: Automatically happens during utility running.
Extracting: select * can be used in a bteq and the rows can
be exported.

Is This Answer Correct ?    3 Yes 0 No

how to load or extract the error table data ?..

Answer / vinay sir(datawarehousing tech

Yuva answer is right and I am adding little more to that.

The error table structure is different from one Utility
to Other.After retrieval we need to understand and analyse
the below error table stuctures.

Syntax: Select * from Databasename.Errortablename

Eg: In Fast Load Error table Fields:
a.Errorcode
b.Error Field
c.DataParcel

In MLOAD the error table fields are:

a.IMPORTSEQ
b.DMLSEQ
c.SMTSEQ
d.SOURCESEQ
e.APPLYSEQ
f.Errorcode
g.ErrorField
h.Uniqueness
i.DataParcel etc.....

Is This Answer Correct ?    1 Yes 0 No

how to load or extract the error table data ?..

Answer / tdguy

to see, just use sel * from, in sql assistant.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Teradata Interview Questions

What is smp and mpp platforms?

0 Answers  

How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?

4 Answers   Comsys, IBM,

Explain about Skew Factor?

6 Answers   TCS,

Explain vproc in teradata?

0 Answers  

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

0 Answers  

IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance

2 Answers   Cap Gemini, IBM, Infosys,

How is MLOAD Client System restarted after execution?

0 Answers  

What happens when a node suffers a downfall?

0 Answers  

What is meant by a Parsing Engine?

0 Answers  

Explain the term 'database' related to relational database management system?

0 Answers  

which utitility can use for loading the data from non-teradata to teradata ?

5 Answers   Wipro,

What is the use of virtual processor connectivity in teradata?

0 Answers  

For more Teradata Interview Questions Click Here
Categories