Interested to Buy Any Domain ? << Click Here >> for more details...
What is meant by MATCHTAG in multiload utility?
- 2 Answers
- 8996 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
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is a dimension table?
What is inner join and outer join?
What are normalization, first normal form, second normal form and third normal form?
Is multi insert ansi standard?
Explain fallback in teradata?
What does sleep function does in fast load?
What is meant by a Parsing Engine?
What is meant by a Clique?
Can we collect statistics on multiple columns?
What do high confidence, low confidence and no confidence mean in explain plan?
What is the function of parser component in teradata?
Discuss the advantages of using partitioned primary index in a query?
How do you see a ddl for an existing table?
Explain BYNET.
