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  

---

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 is SQL Assistence?please eample

4 Answers   IBM,

---

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

0 Answers  

---

What are the various reporting tools in the market?

0 Answers  

---

I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?

4 Answers   IBM,

---

What is the basic syntax for teradata select statement?

0 Answers  

---

Explain teradata architecture?

0 Answers  

---

We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.

2 Answers   IBM,

---

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

0 Answers   HP,

---

What is the default join strategy in Teradata???

5 Answers   IBM,

---

What is a pseudo key? What is its use???

2 Answers   Mphasis,

---