Answer / Krishna Kumar Tiwari

Data Definition Language (DDL) is a part of SQL that allows users to create, modify and delete database structures such as tables, views, indexes, schemas, and other database objects. Common DDL statements include CREATE, ALTER, DROP, RENAME, and TRUNCATE.

Explain clustering algorithm?

1 Answers  

---

Is there any difference in testing database and data ware housing?

1 Answers  

---

How to pivot data using informatica when you have variable amount of pivot rows?

1 Answers  

---

difference between bo 6.5 and bo xi r2

3 Answers   Accenture, Polaris,

---

What is the main difference between star and snowflake star schema? Which one is better and why?

1 Answers  

---

What is difference between query studio and report studio?

1 Answers  

---

what is table partitioning? How it is useful to warehouse database?

1 Answers   EDS, IBM,

---

How can we run the graph? What is the procedure for that?

1 Answers  

---

What is a cube in data warehousing concept?

1 Answers  

---

What are parallel querys and query hints?

1 Answers  

---

Explain which columns go to the fact table and which columns go the dimension table?

1 Answers  

---

Fact table is in normalized or de-normalized form?

1 Answers  

---