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 basic teradata query language?

0 Answers  

Explain and compare pros and cons of start schemas?

0 Answers  

What is partitioned primary index (ppi)?

0 Answers  

Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH CONTAIN ALPHANUMERIC AND NUMERIC VALUES. C1 2A 2B 2V 2H 1 2 3 4 5 i want to retrive numeric values like 1,2,3,4,5 How we can get Plz let me know.Thanks in advance

4 Answers   IBM,

What is the meaning of Caching in Teradata?

0 Answers  

What are teradata utilities?

0 Answers  

How do you eliminate duplicates?

3 Answers  

what is the default character set in teradata,,?

2 Answers   IBM, TCS,

In the Primary Index, what is the score of AMPs that are actively involved?

0 Answers  

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

0 Answers  

what is the difference between bpo and call centre?

2 Answers   American Solutions,

Explain the advantages of partitioned primary index in a query?

0 Answers  

For more Teradata Interview Questions Click Here
Categories