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 BYNET.
What can be achieved by using the teradata rdbms?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
How to find duplicates in a table?
Highlight a few of the important components of Teradata?
Explain the term 'database' related to relational database management system?
What is spool space?
Syntax for case when statement?
Explain and compare pros and cons of start schemas?
While creating table my dba has fallback or no fallback in his ddl. What is that?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Highlight the advantages of PPI(Partition Primary Index).
What are tpump utility limitations?
Why are oltp database designs not generally a good idea for a data warehouse?
Explain the term 'row' related to relational database management system?
