Answer Posted / jaya

slight modification in answer 5:
if Mload got failed in Application phase then either you can
restart it by simply resubmitting the job again and it will
be fine and start from the checkpoint, of the last
block that have updated to disk but if you don't want to
restart it then you need to drop the two error tables one
work table one log table and release mload from the target
table.

Why is the case expression used in teradata?

1074

---

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

1731

---

How to view every column and the columns contained in indexes in teradata?

1054

---

Explain and compare pros and cons of start schemas?

1063

---

What are the components used in smp and massively parallel processing (mpp) machines?

1057

---

Describe the between keyword in teradata?

1036

---

Describe the set operators in teradata.

1002

---

Explain the term 'row' related to relational database management system?

951

---

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1167

---

Explain how spool space is used.

1073

---

What happens when a node suffers a downfall?

1123

---

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

1028

---

Explain the teradata primary index mechanics in detail with a diagram.

973

---

How to eliminate product joins in a teradata sql query?

1024

---

Why does varchar occupy 2 extra bytes?

1189

---