Interested to Buy Any Domain ? << Click Here >> for more details...
What is meant by MATCHTAG in multiload utility?
- 2 Answers
- 8997 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / tdguy
in multiload, five phases are involved. During the DML
phase, all the DML statements are processed. In the next
acquisition phase, the input data is handled and sent to
the worktables. In the fourth application phase, for the
proper sync of input data and DMLs, these match tags are
used. These details can be seen in the mload stats details.
ImportSeq - Sequence number that identifies the IMPORT
command where the error occurred.
DMLSeq - Sequence number for the DML statement involved
with the error
SMTSeq - Sequence number of the DML statement being
carried out when the error was discovered
ApplySeq - Sequence number that tells which APPLY clause
was running when the error occurred
SourceSeq - The number of the data row in the client file
that was being built when the error took place
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain the teradata primary index mechanics in detail with a diagram.
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
How will you solve the problem that occurs during update?
Explain the term 'columns' related to relational database management system?
Is multi insert ansi standard?
What are the newly developed features of Teradata?
What is the use of fallback?
What is multi insert?
What is a level of granularity of a fact table?
Explain the advantages of partitioned primary index in a query?
When tpump is used instead of multiload?
What is the command in bteq to check for session settings ?
Highlight a few of the important components of Teradata?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What is the use of having index on table?
