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

5 Answers   Satyam,

---

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?

0 Answers  

---

what is differences between Fastload and Multiload as per DBA aspect ?

1 Answers   Wipro,

---

how to load or extract the error table data ?

3 Answers  

---

What are tpump utility limitations?

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 are the various indexes in teradata? How to use them? Why are they preferred?

0 Answers  

---

What are the types of tables in Teradata

22 Answers   Cap Gemini, Cognizant, Infosys,

---

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

0 Answers  

---

Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load

4 Answers  

---

Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.

13 Answers  

---

we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.

5 Answers   Accenture, Cognizant,

---