What is meant by MATCHTAG in multiload utility?
- 2 Answers
- 7869 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
Describe primary index in teradata?
Why are oltp database designs not generally a good idea for a data warehouse?
How do you verify a complicated sql?
if collect stats but it show low confidence why?
Explain the term 'row' related to relational database management system?
What is the purpose of upsert command?
What are the scenarios in which full table scans occurs?
What is the purpose of joins in teradata and what are the available join types?
What is database exceptions in teradata?
List the logical and conditional operators that are used with teradata along with their meanings?
Explain the meaning of Amp?
What do you mean by teradata sql assistant?
How do you create tables? Exact syntax, and create profiles, users in teradata?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
Difference between star and snowflake schemas?
