Answer Posted / tdguy

FLOAD--PHASES--2;
MAXIMUM TABLES that can be loaded--1;
DML STATEMENTS SUPPORTED--INSERT;
DDL STATEMENTS SUPPORTED--CREATE,DROP;
ERROR TABLES TO BE DEFINED--YES;
WORK TABLES TO BE DEFINED--NO;

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1085

---

Define views in teradata with syntax.

1058

---

How to eliminate product joins in a teradata sql query?

997

---

List out some of the primary characteristics of teradata.

964

---

How do you verify a complicated sql?

1050

---

How would you load a very large file in teradata in general?

1014

---

Explain BYNET.

983

---

How do you determine the number of sessions?

1046

---

Explain the term 'primary key' related to relational database management system?

1023

---

Explain the advantages of partitioned primary index in a query?

1009

---

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1096

---

Explain how spool space is used.

1059

---

What are the frequently used data types in teradata?

1057

---

Syntax for case when statement?

1043

---

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

1025

---