Interested to Buy Any Domain ? << Click Here >> for more details...
how to load or extract the error table data ?
- 3 Answers
- 7634 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Comment whether bottleneck is an error or not.
What do you mean by ttu in teradata?
Explain Teradata performance tuning and optimization?
Describe the between keyword in teradata?
Highlight a few of the advantages that ETL tools have over Teradata.
Different phases of multiload?
Does SDLC changes when you use Teradata instead of Oracle?
What are types of partition primary index (ppi) in teradata?
What are the joins in teradata and how many types of joins are there in teradata?
If a Node is busy what are the steps you can take to avoid ?
Explain fastload in teradata?
Can you connect multiload from ab initio?
Teradata 
