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;

What is called partitioned primary index (ppi)?

957

---

Define views in teradata with general syntax.

981

---

What is the difference between global temporary tables and volatile temporary tables?

1081

---

Explain parsing engine in teradata?

1021

---

In Teradata, how do we Generate Sequence?

980

---

Steps to create a data model?

1060

---

What are the frequently used data types in teradata?

1001

---

What is database exceptions in teradata?

892

---

What are default access rights in teradata? What explicit right can be given to a user?

1055

---

What do you mean by fastexport in teradata?

939

---

What is the primary index in teradata?

1109

---

What is meant by a Channel Driver?

1139

---

What are some primary characteristics of teradata?

943

---

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1901

---

How many types of joins are there in teradata?

910

---