Answer Posted / yuvaevergreen

For a given empty SET table and input file with same no of
rows, FLOAD is faster than MLOAD.
FLOAD--PHASES--2;MAXIMUM TABLES--1;DML STATEMENTS SUPPORTED-
-INSERT;DDL STATEMENTS SUPPORTED--CREATE,DROP;ERROR TABLES
TO BE DEFINED--YES;WORK TABLES TO BE DEFINED--NO;
MLOAD--PHASES--5;MAXIMUM TABLES--5;DML STATEMENTS SUPPORTED-
-INSERT,DELETE,UPDATE,UPSERT;DDL STATEMENTS SUPPORTED--
DROP;ERROR TABLES TO BE DEFINED--YES;WORK TABLES TO BE
DEFINED--YES;

Explain Teradata performance tuning and optimization?

1219

---

What do you mean by teradata intelliflex?

1164

---

How is MLOAD Teradata Server restarted after execution?

1338

---

Name the five phases that come under MultiLoad Utility.

1024

---

Highlight all the modes that are present under Confidence Level.

1007

---

What is stored procedure in teradata?

1082

---

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

1237

---

What is real time and near real time data warehousing?

1159

---

Explain teradata architecture?

1145

---

What are the available join types in teradata?

1112

---

What is the purpose of upsert command?

1256

---

How does hashing happens in teradata?

1142

---

How many sessions of MAX is PE capable of handling at a particular time?

1132

---

Why managing the data is important?

1054

---

What happens in a conflict? How do you handle that?

1099

---