Answer / tdguy

in multiload, five phases are involved. During the DML
phase, all the DML statements are processed. In the next
acquisition phase, the input data is handled and sent to
the worktables. In the fourth application phase, for the
proper sync of input data and DMLs, these match tags are
used. These details can be seen in the mload stats details.

ImportSeq - Sequence number that identifies the IMPORT
command where the error occurred.
DMLSeq - Sequence number for the DML statement involved
with the error
SMTSeq - Sequence number of the DML statement being
carried out when the error was discovered
ApplySeq - Sequence number that tells which APPLY clause
was running when the error occurred
SourceSeq - The number of the data row in the client file
that was being built when the error took place

Answer / 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.

What is use of compress in terdata?Explain?

11 Answers  

---

How to Extract data from multiple legacy systems?

0 Answers  

---

If table have access lock.In the same table write lock is posible or not?

1 Answers  

---

what is referential constraints?how do you implement RI in teradata?

2 Answers   Wipro,

---

what are the file sizes in your project?

2 Answers  

---

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

0 Answers   IBM,

---

Aborted in Phase 1 data Acquistion Incomplete in fastload?

2 Answers  

---

What are the things to be considered while creating secondary index?

0 Answers  

---

if a error occured in FASTLOAD is the fastload job stops?

1 Answers   CTS, Deloitte,

---

Highlight the differences between Primary Key and Primary Index.

0 Answers  

---

What are tpump utility limitations?

0 Answers  

---

What is the basic syntax for teradata select statement?

0 Answers  

---