What is meant by MATCHTAG in multiload utility?
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
If a Node is busy what are the steps you can take to avoid ?
What are the various etl tools in the market?
Explain Teradata performance tuning and optimization?
What are the functions of a teradata dba?
What do high confidence, low confidence and no confidence mean in explain plan?
How do you define Teradata?
what is sysdba and sysdbc ? which has high priority ?
What tools would you use for that?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Can you connect multiload from ab initio?
Explain fastload in teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Explain fallback in teradata?
Highlight the points of differences between the database and user in Teradata.