What is meant by MATCHTAG in multiload utility?
Answer Posted / pradeep
During the Acquisition phase the actual input data will
also be stored in the worktable so that it may be applied
in Phase 4, the Application Phase. Next, a match tag is
assigned to each DML request that will match it with the
appropriate rows of input data. The match tags will not
actually be used until the data has already been acquired
and is about to be applied to the worktable. This is
somewhat like a student who receives a letter from the
university in the summer that lists his courses,
professor’s names, and classroom locations for the upcoming
semester. The letter is a “match tag” for the student to
his school schedule, although it will not be used for
several months. This matching tag for SQL and data is the
reason that the data is replicated for each SQL statement
using the same data record.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is node? How many nodes and amps used in your previous project?
What are the functions involved in shared information architecture?
What is multi insert?
How will you solve the problem that occurs during update?
What is meant by Teradata Gateway?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Steps to create a data model?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Explain the meaning of Amp?
In the Primary Index, what is the score of AMPs that are actively involved?
what are the day to day activities of teradata DBA ?
What is basic teradata query language?
How to eliminate product joins in a teradata sql query?
How to load specific no.of records using bteq, or fastload,or multiload
What is the use of teradata system software?