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...

how to load or extract the error table data ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the functions of a teradata dba?

1019


How can you track login parameters of users in teradata?

1123


What is bteq script in teradata?

1076


How many types of joins are there in teradata?

910


What is the difference between fastload and multiload? Which one is faster?

1140


what is object level locking ? where do appear this type of locking ?

3441


What is the difference between teradata and oracle?

951


How do you set the session mode parameters in bteq?

1024


What are the functions of a Parser?

1023


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1053


What are the different design perspectives used in teradata?

925


What are the available primary index types?

1145


Why managing the data is important?

953


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2361


Describe primary index in teradata. And what are the available primary index types?

934