Answer Posted / moumita guha

bteq < ./'Script Name'.sh > ./'Script Name'.log

Difference between stored procedure and macro?

1150

---

What are the uses of bynets in multi-node systems?

1012

---

How many tables can you join in v2r5?

1048

---

What is the syntax for case when statement?

1112

---

Which is more efficient group by or distinct to find duplicates?

1070

---

What are the available primary index types?

1201

---

Explain teradata architecture in detail with a diagram.

1097

---

What are the functions involved in shared information architecture?

1058

---

While creating table my dba has fallback or no fallback in his ddl. What is that?

1156

---

What is the opening step in basic teradata query script?

1024

---

How do you do backup and recovery in teradata?

1001

---

Can you fastexport a field, which is primary key by putting equality on that key?

1166

---

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

1727

---

Differentiate database data and data warehouse data?

1092

---

How do you set the session mode parameters in bteq?

1088

---