Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain fastload in teradata?
What are the steps involved in the process flow of the sql statement through channel attached system?
What is a clique?
List out all forms of LOCKS that are available in Teradata.
Can you fastexport a field, which is primary key by putting equality on that key?
What are the different functions performed in development phase?
What is partitioned primary index (ppi)?
Explain the meaning of Amp?
What type of indexing mechanism do we need to use for a typical data warehouse?
Why teradata is used?
if collect stats but it show low confidence why?
What exactly do you know about catching in teradata?
Explain teradata utilities?
What are the various indexes in teradata?
What is a level of granularity of a fact table?
