Answer / Mamta Pal

Denormalization in database design refers to the process of duplicating data in multiple tables with the intention of improving query performance. By reducing the number of joins required to retrieve information, denormalized databases can provide faster response times at the cost of increased redundancy and potential data inconsistencies.

HI THIS IS SHEKAR MY QUTION IS IF I HAD 10 YEARS DATA IN MY SOURCE THEN I WANT TO LOAD ONLY LAST YEAR DATA HOW IT IS POSSIBLE BY USING DATASTAGE7.5.

1 Answers  

---

Explain the term entity type in dbms?

1 Answers  

---

What is e-r model in the dbms?

1 Answers  

---

What is query in database?

1 Answers  

---

What is domain in dbms?

1 Answers  

---

What are five types of database models?

1 Answers  

---

What are the ways to tune reporting services?

1 Answers  

---

What's the difference between file and database?

1 Answers  

---

What is the use of CONSISTENT (Ver 7) option in EXP command ?

1 Answers  

---

What is a clause in terms of sql?

1 Answers  

---

What do you understand by aggregation and atomicity?

1 Answers  

---

What is Library in Forms 4.0 ?

1 Answers  

---