whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?

5 Answers   HCL,

---

What are the various indexes in teradata?

0 Answers  

---

What is the purpose of joins in teradata and what are the available join types?

0 Answers  

---

In your project what type of issues and errors you facing in Teradata

1 Answers   iGate,

---

1.what is activity count? 2.what is skew factor? how it's working explain brefily

5 Answers   Satyam,

---

What is real time and near real time data warehousing?

0 Answers  

---

I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata

3 Answers   Wipro,

---

What does Amp contain and what are all the operations that it performs?

0 Answers  

---

I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.

4 Answers   Cap Gemini,

---

How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?

4 Answers   Comsys, IBM,

---

List out some of the primary characteristics of teradata.

0 Answers  

---

Write a program to show the parser component used in teradata?

0 Answers  

---