Interested to Buy Any Domain ? << Click Here >> for more details...
What is meant by MATCHTAG in multiload utility?
- 2 Answers
- 8896 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 spool space?
Explain the teradata primary index mechanics in detail with a diagram.
How do you define Teradata?
Differentiate database data and data warehouse data?
Can we collect statistics on table level?
Explain the parallel data extension in teradata?
What is oltp?
What is real time and near real time data warehousing?
How do you set the session mode parameters in bteq?
What is partitioned primary index (ppi)?
How does hashing happens in teradata?
What is a dimension table?
What is the use of virtual processor connectivity in teradata?
What is the primary index in teradata?
How do you see a ddl for an existing table?
