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
What do you mean by parsing?
What are the different functions performed in development phase?
Difference between inner join and outer join?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What is TPD?
Difference between multiload and tpump?
How do you determine the number of sessions?
What type of indexing mechanism do we need to use for a typical data warehouse?
Explain fastload in teradata?
How many tables can you join in v2r5?
What is the use of stored procedures in teradata?
What are the frequently used data types in teradata?
Explain teradata vs. Redshift?
Explain Teradata performance tuning and optimization?
How does hashing happens in teradata?
