Answer Posted / dinesh

hi,

yes ofcourse its increasing performance against when work
load increases, in teradata performance wil not affect
because the work load is evevnly distributed acorss all the
amps.

Explain how spool space is used.

1061

---

Comment whether bottleneck is an error or not.

1125

---

How do you do backup and recovery in teradata?

1003

---

What exactly do you know about catching in teradata?

1026

---

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

1046

---

What is the difference between fastload and multiload? Which one is faster?

1203

---

What type of indexing mechanism do we need to use for a typical data warehouse?

1150

---

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2465

---

What are normalization, first normal form, second normal form and third normal form?

1038

---

Differentiate primary key and partition key?

973

---

Explain teradata vs. Redshift?

1002

---

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1223

---

How many types of joins are there in teradata?

958

---

How to select first n records in teradata?

1083

---

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

1093

---