Answer Posted / sunil

Hi, you can not belive on G.K.publisher's book, I have seen
many mistakes. we can refer it but in case of confusion do
not use this book, search for the answers on net or contact
experts around you.

What is the best database software for small businesses?

925

---

Why merge statement is used inside the database?

1108

---

After normalization, what are the conditions which have to keep in mind to de-normalize it?

1051

---

Differentiate between delete and truncate table?

1060

---

How to produce such kind of file?

1107

---

What is database bounce?

1038

---

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

1844

---

How many indexes can be created on a table?

1156

---

What are the types of indexes that are present inside a database?

1128

---

What is difference between server and database?

1095

---

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

1553

---

What is the difference between primary key, foreign key and candidate key?

1115

---

What is the purpose of firebase?

984

---

WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?

2976

---

What is a sequence? Explain it with one example?

1197

---