What is meant by MATCHTAG in multiload utility?
- 2 Answers
- 8057 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
Define views in teradata with general syntax.
Explain the advantages of partitioned primary index in a query?
how can we analyze the locks ?
What is the purpose of indexes?
what are the day to day activities of teradata DBA ?
What is bteq script in teradata?
How you will check the version of teradata?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
How many codd's rules are satisfied by teradata database?
What are different table types used in teradata?
Explain the meaning of Amp?
What is meant by a Parsing Engine?
What are the different functions performed in development phase?
Explain teradata architecture?
Which is faster fastload or multiload?
