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

can i call router is a passive transformation

2 Answers  

What is the difference between global temporary tables and volatile temporary tables?

0 Answers  

what are the default access rights in the teradata?

1 Answers  

Difference between Qualify and group

4 Answers   CTS,

What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .

5 Answers   Accenture,

What are default access rights in teradata?

0 Answers  

Explain the teradata primary index mechanics in detail with a diagram.

0 Answers  

How to run a query in teradata?

0 Answers  

What are the functions of a teradata dba?

0 Answers  

which option is used to restart the fast load script?

2 Answers  

suppose one Cylinder split data blocks are moved from where?

1 Answers  

What is the difference between SI and JI?

2 Answers  

For more Teradata Interview Questions Click Here
Categories