What is meant by MATCHTAG in multiload utility?
- 2 Answers
- 7867 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
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
How does hashing happens in teradata?
What are the components used in smp and massively parallel processing (mpp) machines?
What is the difference between global temporary tables and volatile temporary tables?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Explain the most common data types used in teradata?
What is a three-tier data warehouse?
Difference between stored procedure and macro?
How will you solve the problem that occurs during update?
Why teradata is used?
What do you mean by caching in teradata?
Explain the types of join supports by teradata?
Where is teradata rdbms used?
What are the various etl tools in the market?
What is meant by Teradata Gateway?
