Answer Posted / harjeet singh

thanks for your appriciate definitions

What is dialect in database?

1032

---

I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

1586

---

sparse lookup and where its options we find in OCI and db2?

2265

---

What do you mean by foreign key and primary key?

1086

---

What is a trace file?

1116

---

aht is the difference b/w network & hierarchial & relational dbms????

2254

---

How to implement database security?

1022

---

What is a database call?

1131

---

What is the DIF format and when we will use in teradata

2538

---

What are the various ways to execute a query in teradata?

2652

---

how can you perform lookup range in lookup stage expalin in detail?

1974

---

Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.

2585

---

Explain inner and outer joins with examples.

1218

---

How do you pass parameter in stored procedure?

1245

---

Explain artificial key?

1215

---