I want to write one query How to get Matched records and unmatched records in table?

4 Answers   TCS,

---

Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update

5 Answers   CTS, TCS,

---

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 is identity columns in teradata

2 Answers   Wipro,

---

Explain about Skew Factor?

6 Answers   TCS,

---

---

Highlight the differences between Primary Key and Primary Index.

0 Answers  

---

Aborted in Phase 1 data Acquistion Incomplete in fastload?

2 Answers  

---

I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.

4 Answers  

---

What do high confidence, low confidence and no confidence mean in explain plan?

0 Answers  

---

what is the query for retrieve the unique values(not display the duplicates values) from single table?

6 Answers   IBM,

---

Differentiate primary key and partition key?

0 Answers  

---

What are the different functions performed in development phase?

0 Answers  

---