What is meant by MATCHTAG in multiload utility?
- 2 Answers
- 8225 Views
- Satyam, I also Faced
- E-Mail Answers
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 basic teradata query language?
What are the advantages of teradata?
What is spool space? Why do you get spool space errors?
Highlight the advantages of PPI(Partition Primary Index).
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Write a program to show the parser component used in teradata?
How to eliminate product joins in a teradata sql query?
What happens in a conflict? How do you handle that?
What is the purpose of joins in teradata?
What are the different methods ot loading a dimension table? A fact table etc?
What are some primary characteristics of teradata?
Explain vproc in teradata?
Discuss the advantages of using partitioned primary index in a query?
Explain the term 'columns' related to relational database management system?
Where is teradata rdbms used?
