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

Discuss the advantages of using partitioned primary index in a query?

951

---

How many codd's rules are satisfied by teradata database?

1108

---

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1096

---

Which is faster fastload or multiload?

1107

---

What are types of partition primary index (ppi) in teradata?

1049

---

Explain how spool space is used.

1072

---

Explain teradata vs. Redshift?

1012

---

What are the uses of bynets in multi-node systems?

1028

---

While creating table my dba has fallback or no fallback in his ddl. What is that?

1181

---

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1041

---

What are the functions of a teradata dba?

1072

---

Explain teradata architecture in detail with a diagram.

1111

---

How to Extract data from multiple legacy systems?

1117

---

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1730

---

What are the joins in teradata and how many types of joins are there in teradata?

1004

---