Answer Posted / yuvaevergreen

Fastload utility does not support duplicate rows.
1.Since MS table supports dup rows fastload cannot load MS
table.
2.Restart logic is one of the reason. Fastload is one of the
utility which loads data in blocks(64K). During restart
Fastload sends some of the rows for the second time which
occur after a checkpoint. Due to this Fastload rejects
duplicates.

For example consider 20 rows to be loaded in a table. FL
utility is used to load the table and ckpt is 5 rows. If
restart occurs after 7th row FL may send 6 and 7th to AMPs
during the restart. This records would be considered as
duplicates and rejected.

What is meant by a Least Cost Plan?

1002

---

How to select first n records in teradata?

1040

---

Explain how spool space is used.

1018

---

What is the difference between fastload and multiload?

1290

---

Highlight the points of differences between the database and user in Teradata.

1040

---

what are the uses of fact table and dimension table in banking project?

4491

---

What is spool space? Why do you get spool space errors?

948

---

What are the different softwares used with their functions in teradata?

966

---

How do you create tables? Exact syntax, and create profiles, users in teradata?

974

---

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?

1059

---

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

2149

---

What are the steps involved in the process flow of the sql statement through channel attached system?

1051

---

Explain parsing engine in teradata?

1024

---

What are types of partition primary index (ppi) in teradata?

999

---

Explain the types of join supports by teradata?

935

---