Answer Posted / yuvaevergreen

In terms of speed, fastload would be suitable than mload for
loading an empty table.
But when it comes to multiset tables, mload would be a
better option.
Mload allows use of aggregated values whereas fastload does not.

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?

1113

---

Explain teradata vs. Redshift?

1016

---

What are the updated features of teradata?

1046

---

What is teradata and why it is used?

1097

---

List the logical and conditional operators that are used with teradata along with their meanings?

1001

---

What are some commonly used bteq scripts?

1009

---

What are the available primary index types in teradata.

1032

---

Explain the term 'columns' related to relational database management system?

1066

---

Describe the between keyword in teradata?

1040

---

What is teradata? What are some primary characteristics of teradata?

974

---

Explain parsing engine in teradata?

1089

---

What is the use of stored procedures in teradata?

1004

---

What are the functions involved in shared information architecture?

1073

---

What do high confidence, low confidence and no confidence mean in explain plan?

1048

---

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

984

---