Answer Posted / sivakumar_yandra

whenever we are passing values to the query at runtime then
it is called dynamic query .

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

---

Is storing images in a database a good idea?

1044

---

What is ole db used for?

1065

---

Why merge statement is used inside the database?

1151

---

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

2257

---

Define stored procedure?

1081

---

if i want to display the name of students such that to which city they belong must have count greaer than two

2304

---

What is the difference between database and server?

1072

---

Which is the best graph database?

1013

---

What is sharded database?

1011

---

What is ole db ado?

1043

---

Under which circumstance should you create an index on a table?

1234

---

define primary key index, bitmap index, hash index,virtual indwx

3376

---

What is difference between clustered, non-clustered and unique index?

1125

---

List some advantages of dbms.

1172

---