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 tools would you use for that?

1109

---

How do you determine the number of sessions?

1064

---

What are the various reporting tools in the market?

1072

---

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1153

---

In the Primary Index, what is the score of AMPs that are actively involved?

1078

---

How to load specific no.of records using bteq, or fastload,or multiload

1747

---

Describe primary index in teradata?

1000

---

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

991

---

What is partitioned primary index (ppi)?

1048

---

What are the newly developed features of Teradata?

1031

---

What are the components provided on node?

1043

---

What are the commands to make a new table, change a table and remove a table in teradata?

1132

---

What do you mean by teradata intelliflex?

1107

---

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

1057

---

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2182

---