Answer / Sumit Khari

The degree of a relation is the number of its primary key attributes or columns.

What is bi?

1 Answers  

---

Explain what are the methodologies of data warehousing?

1 Answers  

---

How Materialized Views are linked with Oracle DataWare house?

1 Answers   Kirloskar,

---

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

1 Answers  

---

Explain what are the advantages data mining over traditional approaches?

1 Answers  

---

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

1 Answers  

---

Why is chameleon method used in data warehouse?

1 Answers  

---

What is perform recovery?

1 Answers  

---

What is your spectra photometer working principles?

1 Answers  

---

explain about balanced dimension,

1 Answers  

---

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

1 Answers  

---

What is the difference between aggregate table and materialized view?

1 Answers  

---