Answer Posted / vinay

Hi

I am Vinay Realtime faculty in Teradata.I posted all
interview questions in teradata by Vinay name in this
portal.you can utilise it.You can reach me on
teradatavinay@yahoo.com

What is called partitioned primary index (ppi)?

1000

---

What is the purpose of upsert command?

1148

---

What are some primary characteristics of teradata?

987

---

why use references rather than pointers in the public api, particularly for arguments which are modified?

983

---

Difference between star and snowflake schemas?

1126

---

Explain fallback in teradata?

1031

---

What are the 5 phases in a multiload utility?

1017

---

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

1009

---

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

1222

---

How can you track login parameters of users in teradata?

1174

---

What are differences between teradata and ansi session modes in teradata?

1151

---

What is the purpose of joins in teradata?

1144

---

What are the newly developed features of Teradata?

1006

---

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?

1096

---

What are the various indexes in teradata? How to use them? Why are they preferred?

1044

---