Interested to Buy Any Domain ? << Click Here >> for more details...
What is meant by MATCHTAG in multiload utility?
- 2 Answers
- 8879 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
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are the different functions included in the server software?
What are the functions of a teradata dba?
Highlight a few of the advantages that ETL tools have over Teradata.
What is spool space? Why do you get spool space errors?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
Explain the term 'database' related to relational database management system?
Explain and compare pros and cons of snow flake schemas?
What are aggregate tables? How do you design them using teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What is called partitioned primary index (ppi)?
Define views in teradata with syntax.
Highlight a few of the important components of Teradata?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
