Answer Posted / pratap gangula

Factless fact table contains only foreign keys. We can have two kinds of aggregate functions from the factless fact one is count and other is distinct count.

Define Data Warehousing?

1155

---

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

905

---

In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?

2245

---

What is cost benefit analysis (cba)?

998

---

Explain what is the main difference between inmon and kimball philosophies of data warehousing?

986

---

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

930

---

Explain the definition of normalized and denormalized view?

903

---

After we create a scd table, can we use that particular dimension as a dimension table for star schema?

998

---

What is partitioning? What are the types of partitioning?

1172

---

How did you plan your Data ware house project?

2313

---

What are the different problems that ?Data mining? can solve?

2837

---

Explain in detail abt measure objects? And what is the use of it? How to create it?

1016

---

Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

2344

---

What are components of reportnet?

1079

---

Explain the difference between view and materialized view?

948

---