Answer / Faiz Kidwai

Multivalued Dependency (MVD) is another concept related to functional dependency. It exists when a single value of an attribute X determines multiple values of Y in a relation R. This means that for each unique value of X, there are multiple corresponding values of Y. MVD is important because it can lead to redundancy and anomalies in the database design.

how can one connect two fact tables ? is it possible ? how?

8 Answers   ABC, Oracle, Patni,

---

What is difference between Mapplet and reusable transformation?

3 Answers   UST,

---

I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK AND DATE VALIDITAION LOAD TO TARGET TABLE

1 Answers   Wipro,

---

Explain which are the olap tools available that are supported by oracle?

1 Answers  

---

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1 Answers  

---

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1 Answers  

---

Tell me what is full load & incremental or refresh load?

1 Answers  

---

How would you write a left join statement to return a result set of movie.title�s and director.name�s?

1 Answers  

---

Explain what is the difference between powerplay transformer and power play reports?

1 Answers  

---

What is your spectra photometer working principles?

1 Answers  

---

Explain datawarehousing?

1 Answers  

---

Explain Association algorithm in Data mining?

1 Answers  

---