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
In general, how do you optimze any sql in teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What is spool space? Why do you get spool space errors?
What is the syntax for case when statement?
What are the functions of a Parser?
what are the uses of fact table and dimension table in banking project?
Highlight the advantages of PPI(Partition Primary Index).
Explain fallback in teradata?
Explain teradata architecture?
Explain the most common data types used in teradata?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What is the difference between teradata and basic rdbms?
